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?
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!
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
I am running VLOOKUP to bring a picture located in a specific row cell over a new sheet cell. The issue is that picture comes as a text (picture name). My ultimate goal is to pull that picture into a dashboard, when trying that, just the text comes If I bring picture directly from the smart sheet where picture is located…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
I have a report that is filtered by a particular folder within a shared workspace... everytime I remove items from that folder the report no longer watches the folder, and it turns into individual items within the folder... Is this common behavior? Has anyone else experienced this behavior recently? I want the subfolder to…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.