💸 Calculate Selects
If you're using Notion to track finance, invoices, and balances, one way to minimize a database is to convert text values from a multi-select property into numerical values (or prices). For example, a photographer has selects for excessive expenses. Each select correlates with a dollar amount to add to the client's invoice. Here's how to calculate all selects into a sum.
The Conditions
Expense 1 = $34
Expense 2 = $21
Expense 3 = $50
The Formula Syntax
if(contains(prop("Other Expenses"), "Expense 1"), 34, 0) + if(contains(prop("Other Expenses"), "Expense 2"), 21, 0) + if(contains(prop("Other Expenses"), "Expense 3"), 50, 0)
Add New Select To Formula
Add this string to the end
+ if(contains(prop("Other Expenses"), "Expense 4"), Enter Value, 0)