I need help with formulas
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", "?")
Best Answer
-
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", "")))
Answers
-
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", "")))
-
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", "")))
-
Awesome! Glad this helped get to your solution :-)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 359 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!