Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Help me with a formula where if condition 1 & 2 are met show data from two other columns

Topic Labels: Formulas
364 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Reply 1

How do you want the data combined?

Here’s an example formula, but you may want to adjust it to get the display you want:
IF(AND({Contract Ended?}= "No",({Exclusive?}="Exclusive")), Rights & '\n' & {Holdback Rights}, BLANK())

It will have the content from the {Rights} field, and then a line break, then the content from the {Holdback Rights} field.