Salesforce Imports Apostrophes

Options

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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!