Returning same date as selected date in a dropdown column

Ty Werven

I have a list of dates that people filling out a form can select from a drop down column. I originally had this set up so that the user would fill in the date within a date column but now I want it with the list of dates rather than making them find the exact date themselves.

I had 2 column formulas that took that date column and returned values that were both 3 days and 5 days before the date they originally entered in the date column. These then triggered reminder emails to them when those days were reached.

Can I just use the dropdown date to trigger a similar automation or do I need to have some sort of IF statement that returns a date given in the drop down list, and then use that date column to trigger email notification columns?

Andrée Starå

https://community.smartsheet.com/discussion/133843/returning-same-date-as-selected-date-in-a-dropdown-column

Hi,

I hope you're well and safe!

You can have a list in a dropdown list, but then that needs to be referenced and may be converted to work in the date column. Then you can add workflows to send reminders different periods of days before.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!