I have a regular project plan with several tasks, milestones etc. I was thinking of tiding it up by creating a collapsible section in the very beginning which will contain only the milestones. My idea was to use the simple "=" function so what I did was to simply clink on the cell in the Milestones section -> type = -> scroll down and click on the desired milestone cell. What this does is copying the content of the source cell to the target which is great. However, and this here the problem is, none of the other columns content is parsed over - duration, start/end date etc.
Did anyone ever consider doing such a thing and if so is there a solution for getting the entire row's info parsed over?
PS: I know about Cell linking but that doesn't work from within the same sheet/plan
Help Article Resources
Check out the Formula Handbook template!