Apostrophe ' is added before the number

Nilesh

Hi All,

i got an issue with one of my column -column 1 - '235245

The number is automatically populated via API but its adds an apostrophe ' before the number.

This is a primary number so i can't change the column type to text and again convert it to a number.

Jeff Reisman

This is because Smartsheet thinks you've fed it string values, not number values.

I think you have two options here.

1) Fix the data on the front end with whatever tool you're using to create your API calls, so that it's recognized as number value vs string, or

2) change your API call to write the data to a helper column, then use the VALUE function in your Primary column to convert the string values to number. ex. =VALUE(HelperColumn@row)