Formula

Adolfo E.Adolfo E. ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
04/08/19 Edited 12/09/19

Hello everyone, I'm new to smartsheets and so far my experience has been positive but I'm heading into areas that go beyond what I have learned so far, I used basic formulas to do counts using =SUM, and =COUNTIF but I only have been able to use it to do basic counts. I need a formula that will look at at multiple columns in my case a project name list that has multiple project names and I have another column that has the corresponding status, like completed, In progress, and In Queue. I want the formula to look at the project name column and at the status column and based on the project name I want only to count and tell me how many are in Queue for each different project number. I'm sharing a part of my sheet in hopes it can explain what I'm trying to achieve. thank you in advance if anyone can assist.

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    Absolutely, you can use =Countifs and =Sumifs, which allow you to indicate multiple criteria for each count. 

     

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

    Hi Adolfo,

    Try something like.

    =COUNTIFS(Project:Project; "Project Name"; Status:Status; "Status to count")    

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

    =COUNTIFS(Project:Project, "Project Name", Status:Status, "Status to count")

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

    Did it work?

    Have a fantastic week!

    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.

Sign In or Register to comment.