Returning a Blank in a IF THEN ELSE statement involving a list
I am looking for a way to return a blank for an IF THEN ELSE formula involving a list:
IF x AND y AND z
THEN Values to lookup[LOOKUP: Mapping]
ELSE Return a Blank
The Return a Blank part is what I am having an issue with. I can't use 0 or "Null" as the format of the line item is a list, is there a way to return a blank without adding a list item?
Any assistance would be appreciated, let me know if you have any questions 🙂