If checked subtract using a date, if unchecked subtract using another date

Good afternoon,

I am trying to create a day counter that will be counting until another date is filled. I thought nesting if formula's would work, but so far I am not successfully creating the correct formula. A screenshot below will hopefully help and here is the formula I wrote that is giving me the "Incorrect Argument Set" error message.

=TODAY() - IF(Done@row, false, Created@row, IF(Done@row, true, [Done Date]@row))

Tags:

Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    What about this rendition? Does this work? It checks to see if done is checked and counts accordingly.

    =IF(Done@row = 1, [Done Date]@row - Created@row, TODAY() - Created@row)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!