I would do something along these lines.
IF(Daglig=1,"Daglig",
IF(Ugentlig=1,"Ugentlig",""))
Hi,
Thanks a lot for your reply!
I just tried, and I do see that for example 'Daglig' is added, but the Record still shows up on in 'Empty', so it adds it before the Record is re-made.
I think I misunderstood your question and workflow, so ignore my formula.
You want the due date to be calculated, based on wether it is weekly or daily. Correct?
Also, why separate the completed check mark into daily and weekly?
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.
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
IF({Ugentlig}=1,
DATESTR(DATEADD({Created On},7,'days')),
DATESTR(DATEADD({Created On},1,'days')))
4. convert Hyppighed to a formula and paste this formula
IF(IF({Ugentlig}=1,"Ugentlig","Daglig")
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.
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
IF({Ugentlig}=1,
DATESTR(DATEADD({Created On},7,'days')),
DATESTR(DATEADD({Created On},1,'days')))
4. convert Hyppighed to a formula and paste this formula
IF(IF({Ugentlig}=1,"Ugentlig","Daglig")
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.
Hello!
When inserting the first formula (step 3), I get this:
"Sorry, there was a problem saving this field. Invalid formula. Please check your formula text."
Can you help me figure out what the issue is?
It looks good to me.
Try to erase everything in the curly brackets { } and type the columns back in.
It could be a spelling mistake or something.
IF({}=1,
DATESTR(DATEADD({},7,'days')),
DATESTR(DATEADD({},1,'days')))
