Countif with column and cell reference instead using "XXX" name

Hi, i am building a large list of client that i going to use to create Dashboard with counting items per each client. My question is (maybe it is very basic), is there a way that in the formula Countif i can refer to the cell and column instead or using the "XXXX" name in the formula?

here the formula that i am using and working but as i mention i have around 100 clients names that i will have to type the name in the formula and what i want to do it is just referencing the cell where is already the name of the client. (Similar to excel)

=COUNTIFS({What is it}, "Risk", {Client}, "test client name")

After that i will be doing a ranking with the Top 10 clients. I want to do something dynamic to rank.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!