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.

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.