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:
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.
Hi there, I have just recently worked with Smartsheet's Implementation team to build a Control Center Blueprint. The workspace that holds the solution is titled something very generic and I would like to rename it. Can I do that w/out breaking anything or what steps would I need to take to successfully rename it. Thanks in…
I am creating a form which I want to include a link to a PDF file for anyone completing the form to reference. The PDF is attached to the sheet which the form is associated with. How can I make that PDF accessible to someone completing the form? The closest thing I've found is to create a URL link to the PDF, but that will…
Hi everyone, I accidentally removed the Admin (Owner/Admin access) from one of our Smartsheet sheets, and we're no longer able to manage it as intended. Is it possible to request a backup or restoration of the sheet from Smartsheet Support? If so: Can Smartsheet restore a previous version of the sheet? What information is…
