Formula to Automate Stage
Hello -
I am trying to figure out if there is a way to automate the selection of one of three stages (Not Started, In Progress, Completed) based on Start and Due date columns.
Activities with a Start Date in the future would be 'Not Started', activities with a Due Date in the past would be 'Completed' and anything with a Start Date after today and Due Date in the future would be 'In Progress'.
I've created the formula below but received and 'Unparseable' error. As I was building the formula, I also received an 'Invalid Data Type' error - is this because they are not all text/number columns? The Start and Due date columns are date columns and the Stage column is a dropdown column.
=IF([Start Date]@row, >=TODAY(), "Not Started", IF(AND([Due Date]@row, <=TODAY(), "Completed", "In Progress")))
Any help is appreciated. Thank you!
Andrea
Comments
-
Thank you, Mike. This works for 'Not Started' but does not work for the other status'. Any thoughts on why?
-
Yep. That and I was hopped up on caffeine.
-
Haha. Story of my life.
-
Perfect, thank you both!
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!