I need to skip blank columns in rows

Tsega Thompson

This is my current formula:

=IF(AND([BO1 approval]@row = "Approved", [BO2 approval]@row = "Approved", [BO3 approval]@row = "Approved"), "Approved", IF(OR([BO1 approval]@row = "Denied", [BO2 approval]@row = "Denied", [BO3 approval]@row = "Denied"), "Denied", "Submitted"))

How it works:

If all approvers hits "Approved" =Approved, if any one of them hits"Denied" then it's denied.

Issue: In some cases, all of the approval columns won't be filled. e.g.

BO1 (Bob) - Approved

BO2 (blank) - blank

BO3 (Sara) - Approved

However, I'd like the same logic to apply.

Heather Duff

Hi @Tsega Thompson ,

Try this:

=IF(COUNTIF([BO1 approval]@row:[BO3 Approval]@row, "Denied") > 0, "Denied", IF((COUNTIF([BO1 approval]@row:[BO3 Approval]@row, "Approved") / COUNT([BO1 approval]@row:[BO3 Approval]@row)) = 1, "Approved", "Submitted"))

Let me know if it works!

Best,

Heather