Formula

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

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!