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
Check out the Formula Handbook template!