I am working with 3 fields:
I’m trying to write a formula that will combine [Category] with one of the other two fields, depending on the value in the [Category] field.
This is what I want the formula to say:
If [Category] is “Technology”, return [Category] & - & [Sub-Category: Technology]
If [Category] is “Industry”, return [Category] & - & [Sub-Category: Industry]
The result would look something like this: "Technology - Mobility"
("Technology" is the Category response and "Mobility" is the Sub-Category: Technology response)
I don't know why I am struggling with this formula but this community is always so very helpful, so I thought I would ask. Thank you in advance!