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


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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!