IF Formula Looking at Multiple Columns of Check Boxes

AllisonCowell

I have the formula figured out if only needing to rely on "looking" at one column:

=IF([Approved?]@row = 0, "Pending", "Closed")

I want to update the Status column to also take into consideration the "Approved as GRA Extension?" column. How can I write the formula so that if a box is checked in EITHER the "Approved?" or "Approved as GRA Extension?" columns, the Status is updated to closed? If no boxes are checked, the status should stay as pending.

I do need different columns as there are different automation triggers associated.

KPH

You can nest your IF statements. The first one will check the Approved column. If that cell is checked, it can return "Closed", if it is not checked, rather than returning "Pending", add a second IF to check the "Approved as GSA Extension" column. If that is checked return "Closed", if not return "Pending".

The formula would look like this:

Remove this

=IF([Approved?]@row = 0, "Pending", "Closed")

Add this in bold

=IF([Approved?]@row = 0, IF([Approved as GSA Extension?]@row = 0, "Pending", "Closed"), "Closed")

Alternatively you can use an OR function within the IF and swap the logic around:

=IF(OR([Approved?]@row = 1, [Approved as GSA Extension?]@row = 1), "Closed", "Pending")

This means if "Approved?" is checked or "Approved as GSA Extension?" is checked, return "Closed", otherwise return "Pending".

Either formula would give you this:

KPH

You can nest your IF statements. The first one will check the Approved column. If that cell is checked, it can return "Closed", if it is not checked, rather than returning "Pending", add a second IF to check the "Approved as GSA Extension" column. If that is checked return "Closed", if not return "Pending".

The formula would look like this:

Remove this

=IF([Approved?]@row = 0, "Pending", "Closed")

Add this in bold

=IF([Approved?]@row = 0, IF([Approved as GSA Extension?]@row = 0, "Pending", "Closed"), "Closed")

Alternatively you can use an OR function within the IF and swap the logic around:

=IF(OR([Approved?]@row = 1, [Approved as GSA Extension?]@row = 1), "Closed", "Pending")

This means if "Approved?" is checked or "Approved as GSA Extension?" is checked, return "Closed", otherwise return "Pending".

Either formula would give you this:

AllisonCowell

This worked wonderfully! Thanks for the help!