Getting a date from a "dropdown" column to a date "column"

Ty Werven

I have a form people are able to fill out and select several dates from a list. I want to make it so I can run automations based on what they selected for a date but I need to make a formula to convert the dropdown list column dates to an actual date column dates (I already have it set up this way).

Here is the dropdown list column.

Here are the automations I am trying to set (3 day and 5 day reminders). I would like to make column 17 the column that returns the date in the above column as a date in a date column.

Here is what I think maybe it should look something like? I just have several dates that I also would need to add to the formula, but the formula also does not work for this example so I am not sure if there is an easier way?

=IF([Date-of-Senate]@row, "12/25/24", "12/25/24")

ker9

@Ty Werven

This post should help you:

https://community.smartsheet.com/discussion/82832/convert-text-to-date-format

Ty Werven

@ker9

Not sure how to fine tune this to my own needs.

=DATE(VALUE(RIGHT([Date-of-Senate]@row, 4)), VALUE(MID([Date-of-Senate]@row, FIND("/", [Date-of-Senate]@row) - 2, 2)), VALUE(MID(Date-of-Senate]@row, FIND("/", [Date-of-Senate]@row) + 1, 2)))

ker9

@Ty Werven

Change the "4" in the 1st part (below) to "2". (4 digit year vs 2 digit year.)

=DATE(VALUE(RIGHT([Date-of-Senate]@row, 4)),

The column with this formula must be a date column.

Ty Werven

@ker9

Still getting #unparseable error for some reason. It is in a date column. Is it something to do with the "/"?

=DATE(VALUE(RIGHT([Date-of-Senate]@row, 2)), VALUE(MID([Date-of-Senate]@row, FIND("/", [Date-of-Senate]@row) - 2, 2)) VALUE(MID([Date-of-Senate]@row, FIND("/", [Date-of-Senate]@row) + 1, 2))

ker9

@Ty Werven

This works - I think you are missing the 3rd parenthesis at the end of your formula

=DATE(VALUE(RIGHT([Date-of-Senate]@row, 2)), VALUE(MID([Date-of-Senate]@row, FIND("/", [Date-of-Senate]@row) - 2, 2)), VALUE(MID([Date-of-Senate]@row, FIND("/", [Date-of-Senate]@row) + 1, 2)))

Ty Werven

@ker9

It works! Thanks!