Need help making a formula

I'm new to Smartsheet and bad at formulas. I need help creating a formula for the below data.

I need to count the total number of participants, for each specific assessment type, i.e. DiSC, when they fall into the specific session month, i.e "2" I've used the below formula to count the number of times the assessment has appeared in each session month, but I don't know how to add in the participants to total them up.

=COUNTIFS({Assessment Tracker Sheet Range 1}, "DiSC", {Assessment Tracker Range 2}, "1")

Range 1= Assessment type

Range 2= Session Month

Find more posts tagged with

Accepted answers

All comments

Austin Smith

@mrseibt

Are the participants listed in a multi-select dropdown cell?

mrseibt

@Austin Smith No they are not. It is a text box and the facilitators simple type in the number when they fill out the form.

Austin Smith

@mrseibt

Try this:

=sumifs([number of participants]:[number of participants], [Range 1], "DiSC", [Range 2], "1")

Amber Eakin

Hi @mrseibt - You'll need to use SUMIFS to add up the participants. You'll need to create a reference to your participants column. Give this a try!

=SUMIFS({Number of Participants Column}, {Assessment Tracker Sheet Range 1}, "DiSC", {Assessment Tracker Range 2}, "1")

Please let me know if this works for you!

https://help.smartsheet.com/function/sumifs

mrseibt

Thank you @Austin Smith and @Amber Eakin ! This did what I needed it to do. Since I’m new to using formulas, any suggestions on where to learn tips and tricks that a beginner can understand? Besides trial and error.

Amber Eakin

Absolutely! There are tutorials, and you could use Smartsheet University if you have access.

https://help.smartsheet.com/video_tutorials

Andrée Starå

Hi @mrseibt

I hope you're well and safe!

This is an excellent resource to play around with.

https://www.smartsheet.com/marketplace/template-sets/formula-handbook

I hope that helps!

Be safe, and have a fantastic week!

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!

Austin Smith

@mrseibt

Create a new sheet using templates and search for "formula", there's a formula handbook that Smartsheet's written to help. Outside of that, searching through the Community here is pretty helpful. Typically you won't be the only one with the problem you're looking for an answer to.

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.