Formula won't recognize cell data

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!

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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. 👍️

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.