I have a client who plans events. They need a way to set task length, then have the system calculate the dates backwards from the event date to choose the task start or due date.
Most task management systems I use work the opposite way. You can set a task template based on day 1,2,3 of a project and then set the start date for the project and the due dates go in automatically. But I need to do this with the end date instead.
I was wondering if there was a way to do this in Air Table?
This shouldn’t be a problem.
You have a task table with an item that has a task length of 5 days.
You have a n Event table with an event date field.
In the task table you create a lookup field for the event date in the event table.
For your task start field, add a formula field to the task table as such: DATEADD( your lookup date field, - your task length field ,‘Days’)
You could then get a pretty good overview with calendar views and grouping by event or task start and the like.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.