How to convert from US dollars to local currency

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.

  1. Open your app in the app editor.
  2. 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.
  3.  Locate the column that you would like to edit and click the Edit (pencil) icon.
  4. Select Price from the Type drop-down, if it isn't already selected.
  5. Select your local currency symbol in the Currency symbol drop-down.
  6. Click Done.
  7. Save your changes.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu