Formula won't recognize cell data

CDup

Hi,

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.

Thanks!

Paul Newcome

Double check there are no hidden spaces in the cell data. Smartsheet will store multiple consecutive spaces on the back end but will not display them.

Paul Newcome

Double check there are no hidden spaces in the cell data. Smartsheet will store multiple consecutive spaces on the back end but will not display them.

CDup

Well, you are a super star. Thank you. It still acted a bit funky but I finally got it to copy and paste and for some reason there are several spaces between the first and last name that do not show in the cell. Thanks again!!

Paul Newcome

Happy to help. 👍️