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.