Since column type impacts how AppSheet handles your data, selecting the appropriate column type is important. AppSheet may not have recognized your data as currency either because it doesn't yet recognize Price
in your language or because you used a spreadsheet column header such as Tuition
.
You can change your Column Type to Price
and since AppSheet displays currency in US Dollars, regardless of your selected Data locale, you can select the correct form of currency as well.
- Open your app in the app editor.
- Select Data and select the data that you want to edit in the Data panel.
We've made some improvements to the app editor.
You are opted in to the new editor by default, but you can switch back to the legacy editor at any time.If you are using the legacy editor
Go to Data > Columns and expand the table you would like to edit. - Locate the column that you would like to edit and click the Edit (pencil) icon.
- Select Price from the Type drop-down, if it isn't already selected.
- Select your local currency symbol in the Currency symbol drop-down.
- Click Done.
- Save your changes.