If checked subtract using a date, if unchecked subtract using another date
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))
Help Article Resources
Check out the Formula Handbook template!