How can I prevent numbers from being converted to text when using the rsmartsheet package?

kokokoko

I am using the rsmartsheet package to clean some data. Then I use the replace_sheet_with_csv function to put my new, clean csv file into Smartsheets. My variables that are numbers in R are being converted to text in Smartsheet. I can't use the =VALUE() formula to change them, because that would require many columns and recleaning it every time the new clean data is sent to Smartsheets. But because they are text values, I can't use any of the filters or other logic functions to sort my data in Smartsheets. Any help would be so very appreciated!

kowal

hi @kokokoko,

I have never heard of function replace_sheet_with_CSV but if you choose datashuttle to move your data from csv to smartsheet you have an option during mapping of columns to choose if its text or number.

kokokoko

Thanks. We don't use any premium apps, though, hoping for something that won't require that.