close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()