How Do I link the Status Column to the % Complete Column?
I am looking for a formula that will allow me to update the Status Column (not Schedule Health) to update based on the % Complete (or vice-versa).
Example: If the % Complete is updated to 100% the Status should auto-update to Complete. If the % Complete is anything between greater than 0% and less than 100% the status should update to In Progress.
Alternatively, if the Status is updated to Complete, then the % Complete should be auto-updated to 100%.
Any insight is appreciated.
Best Answer
-
Hi BArmendariz,
It is impossible to build formula for Status and % Complete columns to circle reference, this will lead to error warning.
I recommend to build two "Change cell value" automation workflows to update these 2 columns.
One workflow to update Status based on % Complete and one workflow to update % Complete based on Status
Look at the screnshots below for your reference.
Hope it helps.
Gia Thinh Technology - Smartsheet Solution Partner.
Answers
-
Hi BArmendariz,
It is impossible to build formula for Status and % Complete columns to circle reference, this will lead to error warning.
I recommend to build two "Change cell value" automation workflows to update these 2 columns.
One workflow to update Status based on % Complete and one workflow to update % Complete based on Status
Look at the screnshots below for your reference.
Hope it helps.
Gia Thinh Technology - Smartsheet Solution Partner.
-
Thank you so much; this was a great kick-starter. I added a few more parameters to extend the workflow for additional variables, and it worked perfectly.
The piece I was missing was that this had to be performed as a workflow rather than a formula. 😊
Your help and insight is much appreciated!
-
Happy to help.
Gia Thinh Technology - Smartsheet Solution Partner.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!