need to find values

here i have the data with few country names with status as pass , fail and on hold. attaching screenshots below.

i need to figure out the values with the help of country names

EX; AMERICAS = Pass (no of counts), Failed (no of counts)

India = Pass (no of counts),Failed (no of counts)

plz suggest me how to achieve this.

Best Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 03/26/21 Answer ✓

    Hi @Rakesh Lavishetty

    I hope you're well and safe!

    Try something like this and continue the pattern. (replace the column names with yours)

    Try something like this.

    =COUNTIFS([Region Results]:[Region Results]; Region@row; Status:Status; "Pass")

    The same version but with the below changes for convenience.

    =COUNTIFS([Region Results]:[Region Results], Region@row, Status:Status, "Pass")

    Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!


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

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


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

    W: | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Sing C
    Sing C ✭✭✭✭✭✭
    Answer ✓

    Hi @Rakesh Lavishetty,

    If I'm understanding you correctly you want to find out how many instances of pass, fail, and on hold there are for each country. You could try creating a report on your sheet and grouping by country, then by status, then summarise by the 'Count' field, like this (with group and summary criteria below).

    Sing Chen

    Process Architect, Ceridian



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!