Sign in to join the conversation:
In Google sheets, you can tell if an item is in a dropdown list or not by the handy red caret on the upper right corner of the cell:
Is there an equivalent here?
Hi,
Unfortunately, there isn't, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
One workaround would be to have a list of all available options within the dropdown. You could then use a helper flag type column with a basic formula that will generate a flag if the value input is not on the list.
=IF(NOT(CONTAINS([Selection Column]@row, [Reference Table]:[Reference Table])), 1)
.
You can then either display this flag or use conditional formatting to provide a visible alert that the option is not available, or use it to trigger any number of automations.
Is it possible to auto-populate an email domain in a field where people are asked to enter their email address? For example, I would like users to only have to type their name, without needing to enter anything after the “@” symbol, to reduce the chance of personal email addresses being entered.
This discussion was created from comments split from: I am an editor on a smartsheet but can't edit the sheet.
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
