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!
Answers
-
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.
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!