Thank you for the suggestion. I actually tried the parse number thing too and there is no apostrophe at the Make level for the value before it goes into Smartsheet, but when it does go into Smartsheet, it adds the apostrophe.
Hi
I had that problem too. Make recongnises it as a number but Smartsheet sees it as text, and the parse idea didn’t work for me either,
The only way I got around it was to have a helper column in Smartsheet that make puts data into then I had a value() function in the original column that converted the helper to a number.
Sorry its a bit of work around but it worked for me in my use cases.