i have a table with a "Status" column, and I'm attempting to create a formula for another column ("New Field") that marks "Yes" when the status is "Re-trabalho" However, I want this "Yes" value to persist even if the status changes later on.
Connect
1 Answer
It is not possible with a Notion formula as you need different results.
if status = Re-trabalho, yes, otherwise, no
With that rule the formula is checking the status constantly to see if it is equal to Re-trabalho and display yes, so as soon as it changes to something else, it will display no.
You can try Notion automations if you have a paid account (the little thunder icon in the databases), where that new column marks as yes when status is changed to Re-trabalho and that is it.
That way you may be able to track the status and have a yes only in that new column when the status changes to Re-trabalho.
Related questions
- How to create a new database item based on a trigger status in another database
- How to return a value in another column by using an if-statement?
- Would it be possible to save in one column when a specific entry in another column was last updated?
- Possible to save values of properties in different locations?
- Need help to make progress that will be responsive to Status in second database
Without Answer
-
- 234
- 0
- Jun 11
-
- 606
- 0
- Jun 4
-
- 504
- 0
- May 19
-
- 215
- 0
- May 16
-
- 561
- 0
- Apr 29
-
- 559
- 1
- Mar 20
-
- 540
- 0
- Mar 14
-
- 486
- 0
- Feb 21
- see all
Recent Activities
amandabee asked May 16
Display backlinks in a block or page?amandabee answered May 15
Counting Stars?
...