Check a box if 3 criteria (checkbox columns) are met

Mspencer

I'm trying to identify registrants for a training who no showed using a checkbox column. I have checkbox columns for the following critieria:

• Invited
• Attended
• Declined

I'd like a formula for my No Show column to return a checked box for anyone who:

• Was invited (box checked)
• Did not attend (unchecked box)
• Did not decline (unchecked box)

Current formula I've tried is: =IF(COUNTIFS(InviteSent:InviteSent, 1, Attendance:Attendance, 0, Declined:Declined, 0) > 0, 1)

But it's checking all boxes, even if someone attended.

Carson Penticuff

=IF(AND([InviteSent]@row = 1, [Attendance]@row = 0, [Declined]@row = 0), 1, 0)