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

Find more posts tagged with

Formulas

Accepted answers

Sameer Karkhanis

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

All comments

Sameer Karkhanis

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

Savannah O

This worked - thank you SO MUCH! Smartsheet automatically populates those close brackets so I didn't think to double check them.

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.