IF Statement subtracting Dates
Options
Best Answer
-
Got it
Answers
-
Hopefully I read the field names in your screenshot correctly.
=IF([OK/NG CM]@row <> "CLOSED", Today - [CM DUE DATE]@row, 0)
-
Returning unparseable...also I need if closed is anywhere in that cell
-
Got it
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!