+ Reply to Thread
Results 1 to 2 of 2

can this function do this?

  1. #1
    freestyle
    Guest

    can this function do this?

    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

  2. #2
    Pete_UK
    Guest

    Re: can this function do this?

    Do you mean something like:

    =IF(NOW()>=A1+10,"Yes","No")

    entered in your "Drywall access" column, assuming your dates are in
    column A? If so, then copy the formula down as required.

    Hope this helps.

    Pete


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1