I have a list with multiple Tasks, each Task is grouped in a Category. Every Task also has a Task Start and Task End Date.
I would like to make a calculated column for the Category Start and Category End Date. So when others add a new task to a category, the dates of the category gets updated.
So the Task Start Date is the minimum date of all the start dates
Is this possible using calculated columns and what syntax should I use?
Thanks in advance!