Formulas

Options

hello,

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?

Answers

  • Shanky Paul
    Shanky Paul ✭✭✭✭
    Options

    Hi,

    You can use COUNTIFS formula to pull this information. 

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

    Thank you!

  • abraxton
    Options

    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
    Options

    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.

    Thanks,

    Genevieve

  • abraxton
    Options

    Thank you for your response. please see the screenshot attached

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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)

    =COUNTIFS({STATUS OF REQUIREMENTS}, "Not Approved")

    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.

    Cheers,

    Genevieve

  • abraxton
    Options

    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!