Formulas (Notion)

concat()

Concatenate strings, including output from commands. E.g.:

concat("Created: ", formatDate(prop("Time - Created"), "W"))

This probably isn't a very useful example, as it includes a label in the property field - Excellent way to mess up data integrity.

toNumber()

You need toNumber() for calculations that involve relations: Eventhough the looked-up value might be a number, it isn't as it is a relation. Example:

toNumber(prop("Product unit price")) * prop("Number of products")

Sources

• https://www.notion.so/help/formulas
• https://www.notion.vip/formulas/