Looking for Task Management That Will Calculate Backwards from a Date


#1

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?


#2

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.