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))


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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!