Red Gregory

View Original

Notion For Finance: Convert Multi-Select To Dollar Amount

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)

See this content in the original post

View Example In Notion


See this gallery in the original post