💸

Calculate Multi-Select

Master Tag

Tips & Tricks

Created

Oct 13, 2020 06:06 PM

How It Works

https://www.redgregory.com/notion/2020/10/13/notion-for-finance-convert-multi-select-to-numerical-values

Usage

Contains

Add

Web Tags

Database

Formula

Alternatives

Cover

Conditions

Expense 1 = $34

Expense 2 = $21

Expense 3 = $50

Add Selects Into Sum

Name

Other Expenses

Sum

Expense 1

Expense 2

Expense 3

Expense 2

Expense 3

Expense 1

Expense 2

Expense 3

Formula


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)

Donate