Need help with COUNTIFS formula
I have 2 fields, "Confirmed" (checkbox) and "Status" (drop-down values) to evaluate.
In a 3rd field "# Waiting to be processed", I need a formula to return only the count of those records where "Confirmed" is checked and the "Status" field is blank which means "Status" has not been assigned yet
Essentially, this formula should give me the number of records waiting to be process that's been confirmed by requestor.
I know I should be using COUNTIFS formula but having trouble stringing everything together.
Would you please advise how to write this formula?
Help Article Resources
Check out the Formula Handbook template!