I have a set of data with column F having the start dates for employees on to a project. I then create a gannt chart to the right of that table that creates the dates using the following forumla -
EDATE(F2, SEQUENCE(1, 50, 0))
This is grabbing the first date entered in to column F and is assuming that will be the earliest date for someone to be on a project. This is however not the case and the earliest date could be on any of the valid rows. Is there a way to grab the earliest date in column F (part of a table called AllStaffProjectAllocationTbl and with column header Start Date) in to this formula?