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?
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
I have project with automations sending emails based on specific criteria in the row. These automations are sent via email with a form to acknowledge receipt of the automated email. It would be fantastic if there was a way to track/ensure the email was sent without the need to send a copy of the automated email to my inbox.
