How can I calculate days between dates if a field is blank? (Days open counter)


My column property set to "text/number". The formula I am trying to use: =IF([Completion Date]@row = " ", "Closed", TODAY() - [Creation Date]@row)

I have a column named "Creation Date", then I have a column named "Completion Date". When there is a date in the completion date column I want it to populate "Closed". When the field (Completion Date) is left blank, I want to calculate the number of days it has been open.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!