Drop-down list

Kitty

I have a drop-down list of names on my sheet. I need to remove one of the names and add a new name, but I want to keep the list in alphabetical order. I can't find a way to re-order the names in the dialog box where I add the new name.  Does this mean I have to go back, delete all, and then re-enter the names, placing the new name in its rightful place?

Brian Campbell

Hello Kitty,

 

To the best of my knowledge I don't believe Smartsheet lets you do that.  What I have done for this is copy the list into excel, sort it there and then copy and paste it back.  

 

Hope this helps.

Mike Wilday

Yes, I agree with Michael, this is the easiest way to get that list sorted. Copy, add, sort and paste. 

Andrée Starå

Hi Kitty,

Are you using a Mac or PC?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

 

Kitty

Andree, I am using a PC.  Also, I failed to mention that this is a Contact List, so the drop-down info can't be copied and pasted.  I was hoping someone knew a trick as to how I could move the names up and down.  Oh well, no worries.

Thanks so much!

Kitty

Andrée Starå

Ok. Great idea!

Please submit an Enhancement Request when you have a moment.

Kitty

Andree, I did send in an Enhancement Request. Thanks so much for the handy link!

Have a great day!

Kitty

Andrée Starå

I'm always happy to help!

Have a fantastic weekend!