How do I set a condition so that it removes a particular value from the dropdown list

zainlipa · 01/11/23

I have created this column for preferred exam date(s) and I have added all the future dates for the year 2023 in it. This is a multi-select dropdown and it's for a form.

I want to set up a condition so that:

* IF a value in the dropdown list is same as today's date, the value is removed from the dropdown list.

Is there any way I can set this up?

Otherwise, is there any way to set up a date field in my form where the user can select multiple dates?

Thanks

Ray Lindstrom · 01/11/23

@zainlipa,

You can't have a dropdown list value remove itself based on any criteria. You have to manually add/remove dropdown list values.

If your column is setup as a Dropdown List, and the Allow multiple values per cell is selected, simply add that field to your form, and it will allow you to select multiple dates. Will look like this:

Andrée Starå · 01/12/23

Hi @zainlipa

I hope you're well and safe!

To add to Ray's excellent advice/answer.

Another option could be to use the Premium App, Data Shuttle, to sync the list and remove today's date.

Is that an option?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

zainlipa · 01/16/23

https://community.smartsheet.com/discussion/comment/356826#Comment_356826

Hi @Andrée Starå,

Can I get a walkthrough? or can you link me to any kind of documentation

How do I set a condition so that it removes a particular value from the dropdown list

Answers

Help Article Resources

Categories