Notion Answers

Get help from other Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

Hi, i need to get a specific number based on wich tags are selected on a multi select property.

Here ist a screenshot of what im trying to achieve.

Example:

  1. The option "important" has a value of 2; the option "high workload" has a value of 1. If both properties are selected i want the column "value" to show "3".

  2. The option "event" has a value of -1. If thats the only option selected then "value" should show "-1".

In other words: I want each option from the Tags (multi select) column to represent a numberic value. The selected values should then by summed and the result should be shown in the "value" column.

1 Answer

1vote

abaginski Points570

How about setting up your multiselect with the words you wish to use. Then set up a formula such as:

if(contains(prop("Tags"), "event"), -1, 0) + if(contains(prop("Tags"), "high workload"), 1, 0) + if(contains(prop("Tags"), "important"), 2, 0)

The number is value of the formula would then update depending on the options selected in the multiselect.

Please log in or register to answer this question.

Exclusive for Notion Answers Users

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect