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

Raul Cabrera

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.

Christina09

HI,

If you have a column with the client name already, you can =COUNTIFS({What is it}, "Risk", {Client}, [client name]@row)

here is a litte info about @row: https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

Christina09

HI,

If you have a column with the client name already, you can =COUNTIFS({What is it}, "Risk", {Client}, [client name]@row)

here is a litte info about @row: https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell