Changed Dropdown List Column Property from Multi-Select to Single Select

Kariv ✭✭✭
edited 10/10/23 in Formulas and Functions

I had a Smartsheet column that was originally a multi-select dropdown. I changed it to single select so I could better report on the data. I created a metrics sheet using this column, but it isn't totaling some of the dropdown choices. In the Smartsheet I get the message, "85 cells in 'Location' column have values that aren't dropdown values. I've gone through all of the rows to make sure they only have one dropdown selection. The strange thing is I created a report, and it is accurately capturing the data from each "Location". I also created a metrics sheet using the formula: =SUMIFS({Project-Hours}, {Project-Location}, $[Primary Column]@row and it totals accurately except for the 85 cells. There seems to be a glitch since I changed the column from multi-select to a single dropdown. I logged in/out of Smartsheet. I waited 24 hours and tried again. Any ideas on how I can fix this?

Thanks! Kari


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!