Apostrophe being inserted before number when importing from web form

Apostrophe being inserted before number when importing from web form

I am using MS Forms to collect information and using an integration through Flow to insert responses into Smartsheet. Answers that require a # (I.E. salary or years experience) are being inserted into Smartsheet with an ' before the number which results in my formulas not working. I need to find a way to make this work without manually removing the ' from each row. 

Comments

Sign In or Register to comment.