Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Convert multiple dates in one cell into multiple months in another

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1183 2
cancel
Showing results for 
Search instead for 
Did you mean: 
artichokejoe
5 - Automation Enthusiast
5 - Automation Enthusiast

If I have one date in a single cell, then I would use the formula 

DATETIME_FORMAT({}, 'MMMM) to convert that date into a month. 
 
However, sometimes when using a Look Up I'm pulling multiple dates, separated by commas, into one cell. I'd like to find a formula that will convert all of these multiple dates into the month equivalent. So solving the 'error below'.
 
 artichokejoe_0-1695974987229.png

Any help much appreciated. Thanks. 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

It's simple.
Add the "DATETIME_FORMAT({}, 'MMMM)" formula field to the Lookup source table.
Then, Lookup it.
If you make it a Rollup field instead of a Lookup field and use ARRAYUNIQUE(), only unique values will be displayed.

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

It's simple.
Add the "DATETIME_FORMAT({}, 'MMMM)" formula field to the Lookup source table.
Then, Lookup it.
If you make it a Rollup field instead of a Lookup field and use ARRAYUNIQUE(), only unique values will be displayed.

artichokejoe
5 - Automation Enthusiast
5 - Automation Enthusiast

Fantastic. That's worked. Thank you.