Help

If / then clause in DATETIME_Format Formula

Topic Labels: Formulas
Solved
Jump to Solution
632 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sara_Stahlberg
6 - Interface Innovator
6 - Interface Innovator

Hey Everyone! I need a little assistance with my formula here. Basically, I’m trying to pack alot of information into my primary field so that it appears on the calendar blocks. I have a few fields of information here:

  • Clinic Name
  • Clinic Date
  • Type of Vaccine Offered
  • Number of Doses Offered
  • Primary Team working
  • Supporting Team working (if any)

My question is this: Sometimes there won’t be a supporting team. Is there a way to build in an “if” statement to my formula to indicate “If supporting team isn’t empty, add this clause”, essentially?

Here’s my current formula:

DATETIME_FORMAT({Clinic Date},‘MM-DD-YY’)&" “&{Clinic Name + Activity}&” - “&{Lead Team}&” Supported By “&{Supporting Team}&” - “&{# Doses Scheduled}&” "&{Vaccine Dose Type}

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus
DATETIME_FORMAT({Clinic Date},'MM-DD-YY')
&" "&{Clinic Name + Activity}
&" - "&{Lead Team}
&IF({Supporting Team}, " Supported By "&{Supporting Team})
&" - "&{# Doses Scheduled}
&" "&{Vaccine Dose Type}

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus
DATETIME_FORMAT({Clinic Date},'MM-DD-YY')
&" "&{Clinic Name + Activity}
&" - "&{Lead Team}
&IF({Supporting Team}, " Supported By "&{Supporting Team})
&" - "&{# Doses Scheduled}
&" "&{Vaccine Dose Type}
Sara_Stahlberg
6 - Interface Innovator
6 - Interface Innovator

Thank you so much, @Kamille_Parks !!