Stumped on an Unparseable formula

Murz

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!

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.