I am trying to create a portion on my dashboard where I can show how many items were not approved by the business per workstream.

I can count generally how many were not approved but not sure what formula to use to insert the detail " by workstream".

I use "COUNTIF" should I be using a different formula?


  • Shanky Paul
    Shanky Paul ✭✭✭✭


    You can use COUNTIFS formula to pull this information. 

    =COUNTIFS({workstream column range}, "Workstream name", {status column range}, "Not Approved")

    Thank you!

  • Hi!

    It is not populating on the sheet. I've been sure that all content matches the sheet I am referring to.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @abraxton

    Can we confirm you used countifS? It would be helpful to see a screen capture of your sheet with the formula open (showing the full formula) but please block out sensitive data.



  • Thank you for your response. please see the screenshot attached

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @abraxton

    Thank you for the image! It looks like the formula is working (the syntax is correct) but it's not finding a match for your two criteria so it's returning 0.

    To test and see where the match is failing, try counting each of the criteria individually:

    =COUNTIFS({WORKSTREAM 1}, [Primary Column]@row)


    If one of these returns 0, this tells us that the "criteria" is not being found on your source sheet and you may need to check the {Reference} or the exact text that you're searching for to see where the mismatch is happening.



  • Thank you ! sorry for the late reply. I was able to get the formula to work. thank you for the input it helped alot !

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!