Did you ever get an answer to this question? I think I am looking for something similar. I have two fields that each link to only one record. I want another formula field to either return the enter in Field 1 if the entries are identical, or return the text from both (e.g. “Field 1/Field 2”) if they are different.
Did you ever get an answer to this question? I think I am looking for something similar. I have two fields that each link to only one record. I want another formula field to either return the enter in Field 1 if the entries are identical, or return the text from both (e.g. “Field 1/Field 2”) if they are different.
Your situation is much more straightforward. This formula should give you what you want:
IF({field 1}={field 2},{field 1},{field 1}&", "&{field 2})
@Sydney_Brown
There are ways to provide the functionality you desire – depending on the number of possible modules to consider. For instance, this base assigns a ‘unique’ power-of-2 value to each course and uses SUM(values) rollup to calculate a numeric value for the linked courses. Since there is a unique value for each possible combination of courses, comparing the values will test for matching courses regardless the order in which they are linked.
Admittedly, this is a bit of a kludge – and if you’re dealing with a catalog of hundreds of courses, it’s not an option – but in many instances it can be a quick and simple solution.
I'm having this exact same issue... as this query is 6 years old, I'm not holding out much hope... unless there is some newer function that does this?
