never mind

PAMELA BLACKWELL

Jason Tarpinian

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.

Nick Korna

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!