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
Jun 04, 2020 04:17 PM
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
Jun 04, 2020 04:35 PM
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.