help, im stumped! Trying to sum drop down categories into percent complete

Haywardc

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.

Paul Newcome

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.

Paul Newcome

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.

Haywardc

That worked! Thanks so much @Paul Newcome so helpful

Paul Newcome

Happy to help. 👍️