never mind

Options

Answers

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭
    Options

    At first glance, you've got too many close parenthesis and are cutting off the IF statement before allowing for the FALSE return.

    =IF([Department Chief Approval]@row = "Rejected", Chief@row ) , IF([Person...

    All of those close parenthesis you have before the next IF statement need to be removed.

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @PAMELA BLACKWELL,

    Using the field names from the initial part of your post to make a big nested IF chain (with some ORs thrown in where 1 field serves 2 approval/rejections):

    =IF([Department Chief Approval]@row = "Rejected", Chief@row, IF([Personnel Approval]@row = "Rejected", Personnel@row, IF([Real Estate Approval]@row = "Rejected", [Real Estate]@row, IF([Policy Reviewer 1 Approval]@row = "Rejected", [Policy 1]@row, IF([Policy Reviewer 2 Approval]@row = "Rejected", [Policy 2]@row, IF([School Law Reviewer 1 Approval]@row = "Rejected", [School Law 1]@row, IF([School Law Reviewer 2 Approval]@row = "Rejected", [School Law 2]@row, IF(OR([CEO's Office Initial Review Approval Status]@row = "Rejected", [Post ITS Rejection Approval Decision]@row = "Rejected"), [CEO's Office Initial Review]@row, IF(OR([Procurement Buyer Approval]@row = "Rejected", [Post ITS Rejection Approval Decision - Buyer]@row = "Rejected"), [Buyer Name]@row, IF([CEO's Office Approval]@row = "Rejected", [CEO’s Office]@row))))))))))

    Using some simple sample data (columns squished slightly to fit onto a single screen!):

    Hope this helps, but if I've misunderstood something or you've any problems/questions then just let us know!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!