Now, let us get to know you!
--- Introduce Yourself
--- Answer the Question of the Month
--- Nominate Peak Humans
--- Introduce Yourself
--- Answer the Question of the Month
--- Nominate Peak Humans
Salesforce Imports Apostrophes
Options
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!