Help

Auto populate field from multiple columns

Topic Labels: Dates & Timezones Formulas
174 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