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

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!