How do I use a countif formula to count the number of various priorities?

12/30/18 Edited 12/09/19

I have a column for priority which returns symbols.  Exclamation = high, dash = medium, and down arrow = low.

I have tried various formulas and nothing is working.  

I basically want to know the amount of highs, mediums, and lows in my sheet.

Help please!

Thanks,

Dacey

 

Popular Tags:

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Dacey,

    Try this.

    Change Hight to Medium, Low to count them.

    =COUNTIF(Priority:Priority; "High")    

    The same version but with the below changes for your and others convenience.    

    =COUNTIF(Priority:Priority, "High")

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Did it work?

    Happy Holidays & Happy New Year!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

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

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • The formula with the comma worked perfectly.  Thank you so very much!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Great!

    Happy to help!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

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

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.