Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I have a dropdown list with 5 values and inserted an IF statement into the cells for that column to auto-fill 1 of the 5 values. I noticed when doing this you can no longer access the drop down list. Is there a way to auto-fill so the cell isn't blank to start but still allow users to access the 5 values in the list?
Nick,
It's partly true: you can access the drop down list (with the formula - see below) - until you overwrite it with chosing a value from the list.
I know that it would be fine to have both the auto-fill and the drop-down (back and forth), but it's not possible. In similar cases I make two columns: one with the drop-down for users and one locked column with a formula for myself.
Atus
