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.
Best Answer
-
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
Answers
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!