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

Billy Rock

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

Mike Wilday

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)

Mike Wilday

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)

Billy Rock

That seems to be working great. Thank you so much!

Mike Wilday

Awesome, glad I could be of help. Please accept my answer to your question! :D