I have a series of records that include a Start Date field that I want to incorporate into a larger
CONCATENATE formula.
However, some of the records do not yet have a date and the Start Date field is blank so my formula is returning an #ERROR. I have tried adding an IF=BLANK statement to the formula (see example below) but that doesn't seem to be working either.
IF({Start Date}=BLANK(),(DATETIME_FORMAT({Start Date},'ddd, MMM, DD')
any suggestions on what to try next?