IF statement based on cells in same row

Jodi C

I have a sheet where every row requires two approvals before it's fully approved. What would the formula be to make this work?

For example, approval column 1 is named "initial approval" and approval column 2 is named "COHS approval". Both cells are dropdowns with the options pending, approved, or denied.

I want the first column of the sheet to be "status" and this would say pending, approved, or denied, based on the formula pulling from the other two cells.

ericncarr

Hi @Jodi C your formula would be something like this:

=IF(AND([initial approval]@row = "approved", [COHS approval]@row = "approved"), "approved", IF(OR([initial approval]@row = "denied", [COHS approval]@row = "denied"), "denied", "pending"))

Basically if both are approved then it equals approved, if one or the other equals denied then the status shows as denied, in any other case besides those two the status is pending.

ericncarr

Hi @Jodi C your formula would be something like this:

=IF(AND([initial approval]@row = "approved", [COHS approval]@row = "approved"), "approved", IF(OR([initial approval]@row = "denied", [COHS approval]@row = "denied"), "denied", "pending"))

Basically if both are approved then it equals approved, if one or the other equals denied then the status shows as denied, in any other case besides those two the status is pending.

Jodi C

@ericncarr, that worked, thanks!