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.

Using concatenate only if the values not blank

Topic Labels: Formulas
1563 1
cancel
Showing results for 
Search instead for 
Did you mean: 
LaunchX_Info
4 - Data Explorer
4 - Data Explorer

Hi,
I am trying to use the concatenate formula to combine the name of the class and date while adjusting the date format. However, I want the values to be combined only if the class field is not empty. i have tied variations of blank and if statems without any luck. Here is the formula I am using now but when the class is blank, the fomula still returns the formated date only. Appreciate any help. Thank you!

CONCATENATE({Name of Elective Session}, " “, “on”,” ", DATETIME_FORMAT({Date}, ‘MMM Do’))

1 Reply 1

Hi @LaunchX_Info

Try this in your formula:

IF({Name of Elective Session}!="", CONCATENATE({Name of Elective Session}," on ", DATETIME_FORMAT(Date, 'MMM Do')),"")

I removed the empty quote blocks in the concat and just put spaces on the word " on "