All of my tasks have different duration times it takes to complete. I need a formula for auto populating the due date of the specific task based on the type of task. I.E. if task=email populate the due date -10 days from the launch date.
I have about 15 different tasks all with different completion duration’s. Can someone help with this?
A possibility is creating a new table called “Task Types”
One field in that table would be “time to completion” which you fill with “10” or “5”
On the Task table, lookup the “time to completion” number from the “task type” table and then have a formula field computing the “Due Date”
I’d also have a hard coded due date and if it’s blank then use the due date. This way you could override that formula.
You could also do this with a Zapier integration where any time a new record is added, it would trigger a zap to populate the due date. You’d have to manage it it zapier though.