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", "?")

Find more posts tagged with

Formulas

IF(OR

IF(AND

Accepted answers

=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", "")))

All comments

=Chris Palmer

Hello,

Something like this perhaps?

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 :-)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.