Do you know if it is possible to automate a due date column entry ?
In my case I have a start date and a duration, and I would like to calculate a due date. I found two options but they are not satisfying :
- Use a column formula for due date = start date + duration. In that way I cannot use automations and filter this column, is that correct ?
- Use an automation that when column change, due date = start date duration. The problem is that it works when you change the sart date column, but it does not work when you import an item from excel for example as the cell is empty.
Do you have any ideas or suggestions ?