Looking to create an =IF(CONTAINS Function for a formatted Date field
I'm looking to create an =IF(CONTAINS function to pull the day of the week into a separate column from the formatted date column.
I want the "Event Day" column to turn Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, or Sunday depending on what is in the Event Date column.
I have created this formula, but cannot turn any results - doesn't turn unparseable but just leaves cell blank even when it should be applicable. (haven't done for all 7 days of the week yet to leave less room for error):
=IF(CONTAINS("Mon", [Event Date]@row), "Monday", IF(CONTAINS("Tue", [Event Date]@row), "Tuesday", ""))
We were able to get this function to work, but this is only applicable for one day of the week and we have not been able to duplicate it for all the days of the week.
=IF(CONTAINS("Mon", [Event Date]:[Event Date]), "True", "Mon")
Is anyone able to correct my function or provide alternate suggestions? The reason we want to pull this data is to get this day of the week into Smartsheet Dynamic, as we have learned that Dynamic only allows the date to be formatted in one way in the view, regardless of the formatting in the source report, and it does not include the day of the week. Thank you!
Help Article Resources
Check out the Formula Handbook template!