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 editorby 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 E dit (pencil) icon.
- Select Pricefrom the Typedrop-down, if it isn't already selected.
- Select your local currency symbol in the Currency symboldrop-down.
- Click Done.
- Save your changes.