I've made a table that works as a 'Recurring tasks' table. When someone finishes a job, they'll mark the job as done by using a checkmark (se picture).
The task can either be a daily task or a weekly task. If it's daily the 'Daglig' checkmark will be used, if it's weekly, the 'Ugentlig' checkmark will be used.
Depending on what's chosen the table will find the right "next due date".
The thing is however: the table is grouped by the field 'Hyppighed' (how often a task is being made), so when a task is being checked, it will be moved to an 'Empty' group since 'Hyppighed' isn't automatically filled.
My question is: What should a formula look like in order for it to automatically fill in either 'daily' or 'Weekly' depending on what kind of task it is?
I want this in order for the tasks to move to the right group again.
Hope it makes sense.
That's absolutely correct, yes!
So when it calculates the due date, it moves the "old" Record to a "Done" view and re-makes the Record with the new due date.
Regarding your second question; I think I ended up doing it that way because it's easier for my colleagues to choose. They don't like drop downs for some reason. They want it as easy as possible.
I hope I get your workflow now.
This workflow assumes that a) the task starts the day it is created, and b) there are only daily and weekly tasks. Your team will only mark weekly tasks. Otherwise, it is a daily task.
I would do the following changes:
1. Make a new field call it Created On. Column type is Created Time
2. Convert Deadline to a formula
3. paste the below formula into Deadline
5. delete the Daglig column
Makes sense? I'm assuming you have more daily tasks than weekly tasks.
But what happens when the task is complete? Or is that not something you need to worry about.