Formula error when filtering an unchecked flag column & filled cell (in column)

Hi,

I've been trying to complete a formula that counts the number of unchecked flags when a cell states approved.

Here is my current formula that responds with UNPARS

=COUNTIF([Pause New Grp Reg Reminder]:[Pause New Grp Reg Reminder], OR(1, 0), AND([Facilitator Status - Certificate Completed]@row:[Facilitator Status - Certificate Completed]@row, 1, 0))

Here is a screen shot of the columns


I know my this portion of my formula correctly counts the unchecked flags: =COUNTIF([Pause New Grp Reg Reminder]:[Pause New Grp Reg Reminder], OR(1, 0)

But I then only want to count the Facilitators that have been Approved.

Thanks for you insights!

Char

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!