What formula would you use to lookup a value in column 1, if no value, use value in column 2?
I have a new column “User Company Name” that I want to pull the value from either “Customer Name” or “CM Name”. I tried this formula- IF({Customer Name}, {CM Name}) with no luck.
You will see one column is linked, the other a lookup. Any help would be greatly appreciated. The names used in tables are fictional, examples only.