Say you have three columns that you want to find if a value exists in, then count the columns that contain that string.
In my list, I created three columns.
cOne, cTwo, cThree
All have a field type of single line of text.
Then I created a calculated column named cCalc.
The formula for cCalc is:
In my formula, I’m searching each field for the word Taco. Keep an eye on your case usage. Taco is not the same as taco.