I am not sure how to make this happen. what I need to do is have sort of
reminder when something needs to be done. However, what I was thinking of is
to use IF statement. There is a date column and drywall access required
column. I am wondering if I can use the drywall access required column which
only has entry of yes and no and use the date column to be 10 days later in
some kind of filter so then all the jobs that are ready can have their
drywall access holes checked out or done. I hope you can tell what I mean.
Thanks Jackie
Do you mean something like:
=IF(NOW()gt;=A1 10,quot;Yesquot;,quot;Noquot;)
entered in your quot;Drywall accessquot; column, assuming your dates are in
column A? If so, then copy the formula down as required.
Hope this helps.
Pete
- Feb 22 Thu 2007 20:35
can this function do this?
close
全站熱搜
留言列表
發表留言