EPerez - profile

EPerez · Jan 03, 2023

Hi!Right now I get an #ERROR in Column A when the date is blank. However, I'd like it to return "N/A" instead.The formula below still results in an error. What do you suggest?IF({Formatted Date},CONCATENATE({Formatted Date}," - ",{Event/Release}), "...

EPerez · Jan 03, 2023

Good callout with the date field. Here's what fixed it: IF({Date},CONCATENATE({Formatted Date}," - ",{Event/Release}), "N/A")

User Statistics

User Activity

IF THEN Formula to remove error (complex formula)

Re: IF THEN Formula to remove error (complex formula)