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’))