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!
Best Answer
-
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.
Answers
-
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.
-
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!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!