Trouble Displaying List of Names from a Countif Formula

Hi Community,

Please help :)

I have used the Countif formulae to bring back the number of times the value "Red" Appears in smart sheet.

This brings me a value of 4. (So I am displaying the Value 4 in a Dashboard)

I now would like to display the Names of the Client (Located in Column Name 'Client) so I would see the 4 Clients listed?

Is there a formula that could work this out? Have tried HAS Functions, COUNTM, even INDEX and MATCH but to no avail.

Any help would be appreciated :)

Thanks,

Dan

Find more posts tagged with

Accepted answers

ProductDan

Hi,

I was overthinking this problem, and have solved it, by creating a Report, and displaying this on my Dashboard.

All comments

Anjanesh Vaidya

Hi ProductDan,

As per the condition, you can try the below formula to get the name of the clients, where the status is "Red".

=JOIN(COLLECT(Client:Client, [Current Status]:[Current Status], [Current Status]@row), ",")

The formula is applied to the first cell of the Formula column. You can also implement it in a sheet summary as well.

I hope it will work!

Thankyou!

Anjanesh Vaidya

ProductDan

Hi,

I was overthinking this problem, and have solved it, by creating a Report, and displaying this on my Dashboard.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.