Formula won't recognize cell data



I have several formulas in sheet summary that reference a single person in an assignment column in my sheet. The formulas are repeated multiple times and work just fine, however I seem to have issues with this single person. Any formula that includes this person, does not work. Any insight on how to fix this?

I've tried deleting the formula and trying again and I've tried @cell = "Bernardo Mendez" instead. But it's ONLY this person. The rest of my formulas are exactly the same and I have no issues with every other person.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!