Countifs with Find Newbie Question

Hi all,

New to Smartsheets. I've read several of the post on this topic but can't get it to work on my side.

I have a metrics sheet with everyone's name on it...trying to reference a project sheet "team members" column which list all the different people on a project. I want to show a total next to each person to show how many projects they are involved in.

Here's what I tried...and many other combinations......can't get it to work

=COUNTIFS({Stakeholder}, FIND((Input82), @{Stakeholder}cell))

Find more posts tagged with

Accepted answers

Andrée Starå

@Esharmy

Happy to help!

Try this.

=COUNTIFS({Stakeholder}, HAS(@cell, Input@row))

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @Esharmy

I hope you're well and safe!

Try something like this.

=COUNTIF({Stakeholder}, Input@row)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Esharmy

Thank Andree...that works if I am looking at a column that only has one name per cell....but doesn't work if there are multiple names...that's why I was trying to us the Find or Contains language...any ideas there? Thank you again for the help.

Andrée Starå

@Esharmy

Happy to help!

Try this.

=COUNTIFS({Stakeholder}, HAS(@cell, Input@row))

Esharmy

Thank you Andree! That worked perfectly! Appreciate you!

Andrée Starå

@Esharmy

Excellent!

You're more than welcome!

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.