Hi all,
I created an app for data entry only to speed up the process. Each column has an enum so I can go through and put in the correct values and input complete items into my main sheet quickly. But when I select these options and finish inputting the item... the values that it populates into the sheet have an ' in front of it. Which renders all of my equations useless. (like instead of 7, it inputs '7) how can I fix this??
When selected
What gets put into the spreadsheet
99% sure I just figured it out. The base type is TEXT and not NUMBER. I'm gonna change it and see if that solves it.
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
18 |