Stumped on an Unparseable formula

Hi all,

I have a formula:

=IF([New (Feb 2025) Account Coordinator]@row = "Carrisa Meeks", "GS 1 - WAREHOUSE")

where if the column "New (Feb 2025) Account Coordinator shows Carrisa Meeks, then the cell should populate "GS 1 - WAREHOUSE". It works for all the other cells, exactly the same with a different column name and employee name but this one doesn't. What am I missing?

This is the formula that works:

=IF([New (Feb 2025) Acct Coordinator]@row = "Donna Smith", "GS 3 - FACILITIES AND PLANNING")

help!

Find more posts tagged with

Formulas

#UNPARSEABLE

Accepted answers

All comments

Paul Newcome

In the one that doesn't work, you are spelling out "Account", but in the one that does work you have it abbreviated as "Acct". Make sure whatever is being used as the column name in the formula matches exactly with the column name in the sheet.

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.