Notion Answers

Help between 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

how to apply formula to another column

hi ! i'm new at using Notion formulas. i wonder if i can use it to automatically fill a column which is not a formula. i'm trying to create a ring that shows my progression.

i have :

column 1 : Status
column 2 : #Number (showing as ring, not as number)
column 3 : Formula

what i want to do :

if Status = completed, i want #Number to be 2 (which is a completed ring).
if Status = in progress, i want #Number to be 1 (which is half a ring).
if Status = not started, i want #Number to be 0 (empty ring).

but i don't know how to write a formula that changes another column, not the formula one.

1 Answer

0vote

polle Points78510

You can't write in other properties using formulas, you need to use the formula column itself.

Follow this steps.

1- delete column 2.
2- use this Notion formula in column 3.

if(prop("Status") == "in progress", 1, if(prop("Status") == "completed", 2, 0))

The formula reads as follows: if status is in progress show 1, if status is completed show 2, otherwise show 0.

3- Edit the formula property and change it to percentage and ring.

That will do exactly what you need.

Please log in or register to answer this question.

...

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