I have a formula where if condition 1 and condition 2 are true then show data from another column. What I want to do is have it show data from two different columns if the conditions are true. Here’s the formula: IF(AND({Contract Ended?}= “No”,({Exclusive?}=“Exclusive”)),Rights, BLANK())
What I want to do is add another column - Holdback Rights - to the formula so the data in both shows up in the new column. It seems like it should be simple but no matter what I do it won’t show the data in both.
Thanks in advance!
Jennifer & Mary