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.
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
