Counting Columns based on if they contain certain words/names

Hey

I have a worksheet that has several columns, what I am trying to do is count 1 column IF it holds "specific text/words"

then to add onto this I need it to only count if a name shows up in 1 of 3 other columns.


I've tried 15 different formulas now and none of them seem to be working. I thought it would be as simple as a "countif with a contains (OR)" obviously thats not how id written the formula out

Can anyone help me out?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!