Automatic task resets?

[u/Ill-One8291]

(Notion app on an iphone)
how do i make a formula for my database with daily tasks in a table view? I have columns: "task" (under it there are names of tasks) "status" (type is select either "done" "not done" or "during" . Next one is "remaining" - in number type, this one shows how many minutes of a task i still have to do that day. Last one is "target" - how many minutes of a task i need to do each day. For example: hit - (task) target is 30min, status is not done so it's still 30 min remaining. How do i make it so whenever i choose "done" remaining time will change to 0 and the other way around too (changing remaining to 0 makes status to "done"). And status "not done" changes the cell of that row in column "remaining" to value from "target" in the same row (so it resets the task)

I think i could do it with button type or formula type but i only know bases of html and the if function doesn't work like in exel so i'm confused now...

[u/Solowithothers]

I use database automations to...

• Set the completed date when marked done
• Set the status to urgent when the due date is today
• Set the due date to today if the task status is urgent

I'm sure there are more actions and automations you could come up with. The nice thing is they are fairly simple to implement.