Multiple IF and IF (AND) arguments in one formula
Does anyone see any obvious issues with this string? I'm trying to pull from two columns [VA Feed status], [QA Feed status] and output one status based on the column statuses. This is a combination of IF(AND) and also just IF statements.
I'm currently receiving #UNPARSEABLE
=IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed aligned to sprint"), "Aligned to Sprint", IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed in development"), "In Development", IF(AND([VO Feed status]@row = "Pending file receipt", [QA Feed Status]@row = "QA: feed in testing"), "In UAT", IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed in production"), "In Production", IF([VO Feed status]@row = "VO: Backlog", "Backlog", IF([VO Feed status]@row = "VO: Pending initial VO (Aon)", "Pending Vendor Outreach", IF([VO Feed status]@row = "VO: Pending vendor response", "Vendor Outreach Ongoing", IF([VO Feed status]@row = "VO: Intake call scheduled", "Vendor Outreach Ongoing", IF([VO Feed status]@row = "VO: Pending legal and/or fee execution", "Vendor Outreach Ongoing", IF([VO Feed status]@row = "VO: Pending file receipt", "Data Receipt & Acceptance", "error"))))))))))))))
Best Answer
-
You have extra closing brackets in your formula. Try the below,
=IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed aligned to sprint"), "Aligned to Sprint", IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed in development"), "In Development", IF(AND([VO Feed status]@row = "Pending file receipt", [QA Feed Status]@row = "QA: feed in testing"), "In UAT", IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed in production"), "In Production", IF([VO Feed status]@row = "VO: Backlog", "Backlog", IF([VO Feed status]@row = "VO: Pending initial VO (Aon)", "Pending Vendor Outreach", IF([VO Feed status]@row = "VO: Pending vendor response", "Vendor Outreach Ongoing", IF([VO Feed status]@row = "VO: Intake call scheduled", "Vendor Outreach Ongoing", IF([VO Feed status]@row = "VO: Pending legal and/or fee execution", "Vendor Outreach Ongoing", IF([VO Feed status]@row = "VO: Pending file receipt", "Data Receipt & Acceptance", "error") ) ) ) ) ) ) ) ) )
Answers
-
You have extra closing brackets in your formula. Try the below,
=IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed aligned to sprint"), "Aligned to Sprint", IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed in development"), "In Development", IF(AND([VO Feed status]@row = "Pending file receipt", [QA Feed Status]@row = "QA: feed in testing"), "In UAT", IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed in production"), "In Production", IF([VO Feed status]@row = "VO: Backlog", "Backlog", IF([VO Feed status]@row = "VO: Pending initial VO (Aon)", "Pending Vendor Outreach", IF([VO Feed status]@row = "VO: Pending vendor response", "Vendor Outreach Ongoing", IF([VO Feed status]@row = "VO: Intake call scheduled", "Vendor Outreach Ongoing", IF([VO Feed status]@row = "VO: Pending legal and/or fee execution", "Vendor Outreach Ongoing", IF([VO Feed status]@row = "VO: Pending file receipt", "Data Receipt & Acceptance", "error") ) ) ) ) ) ) ) ) )
-
This worked - thank you SO MUCH! Smartsheet automatically populates those close brackets so I didn't think to double check them.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!