If statement % complete column
ceej
✭✭
I want to create an if statement in my % complete column such that % complete goes to 100% when another column has a date.
Comments
-
Try (Change Due Date to your column name):
=IF(ISDATE([Due Date]@row), 1, 0)
-
Thanks! It works if I eliminate any dependency for the %change column.
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!