Formulas

abraxton

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?

Shanky Paul

Hi,

You can use COUNTIFS formula to pull this information. 

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

Thank you!

abraxton

Hi!

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

Genevieve P.

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

SS.PNG

Thank you for your response. please see the screenshot attached

Genevieve P.

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

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