How to make dropdown options become unavailable (in both forms and sheets) once they’ve already been selected.
Example: If a patient books an appointment, that time slot is automatically removed or disabled so it can’t be chosen again.
Sign in to see the current vote count, add your own vote, or leave a comment.
Hello,
For ease of form use (and keeping a positive tone), I've created some drop down menu where users can select "all that are true" from a variety of options. It would be useful for those of us viewing the submitted forms to be able to easily see which options were not selected- as those highlight gaps in service.
The only way I can find to do this right now is very convoluted and clunky involving work flows with lots of conditions. It would be wonderful to have an option to select "if any of these items are unselected- populate unselected items in designated cell".
thank you!
Hello!
Any updates on the above suggestion? It would be amazing if the document builder was able to display the options not selected in Smartsheet.
Thank you!
This would be useful for me too - maybe have the "not" function return the set of un-selected allowed values when applied to a dropdown data type?
Thank you for your consideration!
I wonder if that could be managed through an integration with calendly or some other calendar app?
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
Dashboard widgets are currently mostly static. I can display counts and charts, but I cannot click into a specific part of a widget to drill into the underlying records. It would be a big usability improvement if widgets supported interactive drill-down. For example: Click a bar segment (or stacked segment) to open the…
