Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Duplicate Values in column

Gina Brummels
edited 12/09/19 in Archived 2016 Posts

I am having an issue with a sheet where we had changed some of the values in the dropdown of column properties, but because the old values were used previously, unless a user selects the dropdown, they can start typing and select the old value. 

It creates an issue when trying to analyze the data. even when we override the incorrect options, they still show up for users to select when typing. 

Any suggestions would be great



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    Change the Dropdown list and the column at the same time (meaning very quickly after doing the first)


    1. fix drop down list 

    2. filter for the incorrect value and change them all

    3. save

    4. repeat


    That fixes the source (the dropdown) and old values (in the column)


    I hope that helps.



This discussion has been closed.