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.

Auto populate field from multiple columns

Topic Labels: Dates & Timezones Formulas
544 1
cancel
Showing results for 
Search instead for 
Did you mean: 
5arahlou
4 - Data Explorer
4 - Data Explorer

Hi,

I cant for the life of me find a formula to 

I have 3 date columns in each record, only one of these will be populated per record, i want to create an additional single column which would auto populate with the date from either of these 3 fields so i can format it to a week number (and YY of possible).

Is this possible to do and if so can anyone help with the formulae for this please?

Thank you so much, Sarah 🙂

1 Reply 1

Try:

DATETIME_FORMAT(
  {Date 1} & {Date 2} & {Date 3},
  "WW YYYY"
)

Screenshot 2024-05-30 at 2.37.59 PM.png