I have read through the other threads regarding this subject of blank cells in a formula but wasn’t able to successfully implement a solution.
In my primary field, I have a formula combining the Sponsor Name with the date the Ad Copy was submitted. The two are separated by a space.
I would like to change this so that if a Sponsor Name cell is empty, that part of the formula returns “?”. Same with the “Copy Ready Format.” If that is blank, I’d like it to return “?” too.
Can you help me write the formula the way?
Thank you in advance!