What is a formula to capture % Complete when the "Status" changes?
Example:
When I change the Status column dropdown option to "Complete" how do I write a formula to automatically change the percent complete?
I.E.
Status is "Not Started" = Percent Complete is "0%"
Status is "In Progress = Percent Complete is "50%"
Status is Complete = Percent Complete is "100%"
Answers
-
I do it with workflows because I want the option of someone entering either in % Completed or Status.
With Workflows you can update either Percent Complete or Status to change the other field.
Workflow 1: 1-99% Percent Complete, change cell value to In Progress
Workflow 2: 100% Percent Complete, change cell value to Complete
Workflow 3: 0% Percent Complete, change cell value to Not Started
Workflow 4: Status is Complete, change Percent Complete to 100%
To do it with a formula, You can only update % Complete and then change Status willl change based on the formula..
=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "In Progress"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!