Assistance with COUNTIFS formula...(New to Smartsheet/Formulas)

Hello, I am new to Smartsheet and formulas...I need assistance with a formula (creating a formula sheet for a dashboard).

My formula references another sheet and I want it to count the IN-PROGRESS and UPCOMING Training for an individual trainer. I've created a few formulas that work, but not sure how to create them to count for 2 different training statuses.

INFO:

Sheet Name: Class Tracker

Trainer Name: Aaron

Training Status: IN-PROGRESS, UPCOMING, COMPLETED

FORMULA to count "In-Progress" for Trainer: Aaron..

=COUNTIFS({Class Tracker Range 2}, "Aaron", {Class Tracker Range 1}, "IN-PROGRESS"

Any ideas on how to count both In-Progress and Upcoming?? So far I keep getting #UNPARSEABLE

Thanks!

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Hi @Jani Luna ,

Try:

=COUNTIFS({Class Tracker Range 2}, "Aaron", {Class Tracker Range 1}, OR(@cell="IN-PROGRESS" ,@cell= "UPCOMING"))

Work?

Mark

All comments

Mark Cronk

Hi @Jani Luna ,

Try:

=COUNTIFS({Class Tracker Range 2}, "Aaron", {Class Tracker Range 1}, OR(@cell="IN-PROGRESS" ,@cell= "UPCOMING"))

Work?

Mark

Jani Luna

Yes! @Mark Cronk - Thank you!

Mark Cronk

You're welcome. Thank you for contributing to the Community.

Be Well,

Mark

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.