I need help with formulas

fiorellag

I am working on formulas to get approvals in one of my sheets - But there are more than 2 options and I'm finding it a bit confusing…

• IF both directors APPROVE = Trade Off Accepted
• IF one director APPROVES and the other one is PENDING = Pending Acceptance (Would I need two of these?)
• IF both directors REJECT = Trade Off Rejected

So far I have this:

=IF(AND([Product Director Decision]@row = "Approved", [Technology Director Decision]@row = "Approved"), "Trade Off Accepted", "?")

=Chris Palmer

Hello,

Something like this perhaps?

=IF(OR([Product Director Decision]@row = "Pending", [Technology Director Decision]@row = "Pending"), "Pending Acceptance", IF(AND([Product Director Decision]@row = "Approved", [Technology Director Decision]@row = "Approved"), "Trade Off Accepted", IF(AND([Product Director Decision]@row = "Reject", [Technology Director Decision]@row = "Reject"), "Trade Off Rejected", "")))

=Chris Palmer

Hello,

Something like this perhaps?

=IF(OR([Product Director Decision]@row = "Pending", [Technology Director Decision]@row = "Pending"), "Pending Acceptance", IF(AND([Product Director Decision]@row = "Approved", [Technology Director Decision]@row = "Approved"), "Trade Off Accepted", IF(AND([Product Director Decision]@row = "Reject", [Technology Director Decision]@row = "Reject"), "Trade Off Rejected", "")))

fiorellag

Thank you! That one helped me!

I worked off of that one and came up with this one:

=IF(OR([Product Director Decision]@row = "Requested", [Technology Director Decision]@row = " Requested"), "Pending Acceptance", IF(AND([Product Director Decision]@row = "Approved", [Technology Director Decision]@row = "Approved"), "Trade Off Accepted", IF(AND([Product Director Decision]@row = "Approved", [Technology Director Decision]@row = "Requested"), "Pending Acceptance", IF(AND([Product Director Decision]@row = "Requested", [Technology Director Decision]@row = "Approved"), "Pending Acceptance", IF(AND([Product Director Decision]@row = "Reject", [Technology Director Decision]@row = "Reject"), "Trade Off Rejected", "")))

=Chris Palmer

https://community.smartsheet.com/discussion/comment/450131#Comment_450131

Awesome! Glad this helped get to your solution :-)