Dec 09, 2019 11:24 AM
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?
Dec 09, 2019 11:38 AM
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.
Dec 10, 2019 08:27 AM
Can you provide me with what that formula might look like?
Dec 10, 2019 08:28 AM
I am really struggling with this
Dec 10, 2019 08:35 PM
Here you go - this is a link to a sample base I made with some formulas. It’s not elegant, but may give you some guidance.
I’m curious to understand more of what you’re doing. Would you mind sharing why this functionality is helpful?
Dec 10, 2019 09:14 PM
Also just came across this and think it may also help!
Dec 11, 2019 02:39 AM
I edited the base (possibly the original?) to add the override due date function you mentioned above, using a simple IF statement, because that was the idea that brought me here.
Dec 11, 2019 10:56 AM
Thanks for making the adjustment!