Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Countif rows meets multiple criteria

Melanie Kourbage
Melanie Kourbage ✭✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

I'm new to Smartsheet, and I'm trying to count the number of incomplete tasks by SME area within a task list. How do I write COUNTIF formula that will count a row IF the Status column does not equal Complete AND the Area column equals Vocab?

 

The ultimate goal is to depict on a Sight the number of incomplete (i.e., active) PM, Vocab, and Tech tasks across all project sheets. At present, my strategy is to create totals at the top of each project sheet, link them to a summary sheet to aggregate all totals aross projects, then create a widget of the highest-level info in the summary sheet for the Sight.  Which seems like more steps than it should be.

 

Any advice, shortcuts, etc., that people can suggest would be appreciated.

 

Thanks!

Tags:

Comments

  • J. Craig Williams
    J. Craig Williams Top Contributor

    Use COUNTIFS instead of COUNTIF

     

    the syntax is

     

    COUNTIFS(range1, value1, range2, value2, etc..)

     

    something like this:

     

    =COUNTIFS([Status]:[Status], <> "Complete", [Area]:[Area],"Vocab")

     

    Note that the [] will be removed when the formula is saved.

     

    Craig

  • Melanie Kourbage
    Melanie Kourbage ✭✭✭✭✭✭
    edited 11/15/16

    Thank you!  That did it!

  • Marc Shecter
    Marc Shecter ✭✭✭✭✭✭

    This helped me too.

This discussion has been closed.