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

Options
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

Gina

Comments

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

    Gina,

     

    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.

     

    Craig

This discussion has been closed.