AppSheet and SmartSheet
Hello, I set up an AppSheet Mobile app to feed into a sheet. It looks like there is some data matching issue, as the data appears to come in as text.
In AppSheet the data is set up as Percent with Max Min and Interval levels of 100, 0 and 50. This gives me three options, 0%, 50% & 100%.
In my sheet the column is set up as Drop Down List with restricted values of 0%, 50% and 100%.
The data seems to transfer fine from AppSheet but it is left justified and is making my formulas give errors, which makes me think it is coming over as text.
I've tried different Data Types in both AppSheet and Smartsheet with no luck.
I've used a similar setup on another sheet and it worked fine. Anyone have any ideas?