Now, let us get to know you!
--- Introduce Yourself
--- Answer the Question of the Month
--- Connect with your Peers
--- Introduce Yourself
--- Answer the Question of the Month
--- Connect with your Peers
Salesforce Imports Apostrophes
rosegarretson
✭✭✭✭
This is a public service announcement...
If you have an Index/Match that isn't working, and the source sheet is a data mesh or data shuttle from Salesforce, check the numeric field to make sure there isn't a leading apostrophe.
The apostrophe will not appear until you click in the cell. You can rid of it with a helper column and a formula like: =LEFT([Column Name]@row, LEN([Bus Loc #]@row) - 1).
Cheers!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Show & Tell
- Hi , Can anyone tell me what this is asking for? I was trying to recreate a very advanced automation that was setup by our Manufacturing Engineering Manager. I did a save as so that I did not mess wit…
- Shout it from the rooftops: Our February Member Spotlight is @Julia L Rumburg, nominated by YOU, the Community! Seeing you recognize and appreciate each other is such a beautiful thing. Julia is a Str…
- Hey there, Community! We have a very exciting milestone to celebrate with all of you — The Smartsheet Community is hitting its 10 year anniversary this month. Can you believe it? Read all about it on …
