Setting a status based on date fields
Is there a way that I can update or set a status based on data in 3 other fields? What I am trying to do is set a status based on data being entered in 3 other fields - if those fields are blank, then status would be 'In Progress' if those fields contain data (dates or text) status is 'Complete'? Is this doable?
Answers
-
Hi Bianca,
You'll use nested IF statement with AND and OR. You'll need to add the right column names but your formula will be:
=IF(AND(ISDATE(start@row), ISDATE(end@row), ISDATE(mid@row)),"Complete", IF(OR(ISDATE(start@row), ISDATE(end@row), ISDATE(mid@row)), "In Progress", "Not Started"))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
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!