help, im stumped! Trying to sum drop down categories into percent complete
Hi all! My department Smartsheet used to be run by someone else, but I am now in charge of it. I do not have the formula knowledge to fix one of the formulas. Any help is hugely appreciated! I am stumped!
Feel free to watch the attached video of me doing my best to walk you through the Smartsheet and problem I am having.
https://www.dropbox.com/s/r87mnlqrdmq2tpx/test-20221011_131100-Meeting%20Recording.mp4?dl=0
The sheet is set up with columns on the right hand side utilizing the SUM formula to calculate the percentage complete of the drop downs options. The drop downs change their completion color based on the set conditional formatting and the percent is calculated by these completions.
I had to edit the verbiage in one of the drop down options (originally labeled "In the ODBC", now labeled "In the ODBC for MBV"). When I changed this name, the completion percent status went to 0% (assuming bc it is no longer linked to the correct drop down option).
How do I change the formula to calculate the percentage of the new drop down option? It is still trying to calculate the previously used term which is no longer connected to any data.
I have tried rewriting the formula with the new name, but that only leads to error.
Best Answer
-
It looks like the formula you are showing is in row 1 and it references the 3 rows below it (2 - 4). If you swap out the verbiage with the new dropdown selection in the formulas in those 3 columns then that top row should be working for you again.
Answers
-
It looks like the formula you are showing is in row 1 and it references the 3 rows below it (2 - 4). If you swap out the verbiage with the new dropdown selection in the formulas in those 3 columns then that top row should be working for you again.
-
That worked! Thanks so much @Paul Newcome so helpful
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!