Completion % Formula Based On Drop Down Options
Am running into a bit of difficulty attempting to input a formula in the sheet I have created. I am wanting to have the completion % column auto populate with predetermined values based on what is selected in a dropdown menu from the 'status' column, i.e., completion % automatically goes to 50% if status is 'in progress'. The completion % column currently requires manual entry and was setup from the standard predecessor/duration from project settings, which won't let me input a formula.
Considered removing the project settings for completion % and recreating a column but I do like the rollup % aspect for the various department aspects.
Answers
-
Hi @Nick F.
I hope you're well and safe!
Try something like this. (and continue the pattern for the other options)
=IF(Status@row = "In Progress", 0.5)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå , yes that does work but when i create a new column. Looks like the issue I am having is due to the below since you can't put a formula into the complete % column when using these settings...
I was hoping to avoid creating another column for completion % since i like the rollup functionality for parent functions.. Do you have a formula for rolling up the completion % for sub tasks into the parent task that is similar to this function?
-
Excellent!
Happy to help!
You can use a Workflow combined with the Change a Cell Action to update the % Complete column when using the Dependencies feature.
Did that work?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!