Ability to format formula results as currency

NotionApps Roadmap
1

In Notion, when you format a formula result to use a currency, the view field component only shows it as an unformatted number.

2

Hey Laura! There is an issue with Notion that prevents us from accessing the currency data inside NotionApps. I will raise the issue with Notion team. Meanwhile, as a workaround, you could add a “$”/“€” currency sign to the label of the component as an indication to the user that the value is in dollars.

3

This request is covered by a workaround, and it is on the roadmap as live.

Problem

In Notion, a formula can be displayed as currency. On the app screen, that same formula shows as a plain number, without the currency symbol or the currency formatting.

Why this is a workaround

Notion does not send the currency format of a formula to other products. The app receives the number, so it cannot reconstruct the currency setting from Notion. The symbol belongs in the component label, or in a separate text value that already includes the symbol. Formatting the formula inside NotionApps was not added because the currency metadata is not available.

How to use it

Put the symbol in the label when the number itself can stay plain.

  1. Open the screen that shows the formula.
  2. Select the component bound to that formula.
  3. Set the label to include the symbol and, if it helps, the code. For example, Amount ($) or Amount (EUR).
  4. Publish. The value is still the number Notion returned. The label tells the person what the number is.

Put the symbol in the value when the label is not enough.

  1. In Notion, add a second formula that returns text and includes the symbol, for example a formula whose result looks like $12.50.
  2. In NotionApps, reload the database.
  3. Open Databases, then Calculated properties, and select the new formula. If NotionApps cannot recalculate that recipe, leave Recalculate off. The app then shows the value Notion already computed.
  4. Replace the number component with the text formula, or show both.
  5. Publish and compare one row with Notion. The symbol should be visible in the app because it is part of the text, not part of Notion’s currency setting.

Do this per currency if one database mixes currencies. A single label of “$” is wrong for a row that is in euros. In that case the text formula should include the symbol that belongs to that row.

Documentation