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

Jani Luna

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!

Mark Cronk

Hi @Jani Luna ,

Try:

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

Work?

Mark

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