never mind
Answers
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!