I’m looking to use Coda Task as a way to onboarding some clients. A few things I’m trying to do.
If I have a task list of 5 task. I want to use the following.
Task name, Start Date, End Date, SLA
Task 1 starts everything once that End date is setup I then want Task 2 to have an End Date of Task 1 End Date + SLA
SLA is going to be a random number to get the task completed.
Example:
Task 1 Fill out form. End date 3-1
Task 2 Assign Team. End Date = 3-1 + 2 = 3-3. So SLA field on task 2 is 2, and so since task 1 was done on 3-1 we have to complete task 2 by 3-3. Does this make sense? How can we do this?
Hello @Bryan_Long ,
Code lends itself perfectly for just doing that.
From your sample it is not really clear if every project is going to have all 5 tasks, if there is more than one project or if you will start from scratch when a project is done.
Please share a dummy doc that resembles what your doc is going to look like once it works, and one of us will help you with the formulas.
Basic date arithmetic is very simple: you can have formula for your column like this:
=thisRowStartDate + taskbase.filter(TaskName.contains(thisRow.TaskName)).SLA
but at this point it is just guessing what you are building.
It is easy for us to build you a sample document, but you learn a lot more from setting something up and then get suggestions and improvements from the more experienced Coda community members.
Greetings, Joost