July 10, 2020
I have downloaded "Project Management Dashboard" from the given link at you tube. I have read many comments and your reply about the alternate formula of Sequence. I am at beginner level in excel, can you please write here a exact formula. Secondly when I try to write the formula in K5, it appears a pop up message "you cannot change a part of array"?
it will be great help and I will really appreciate you if you solve my problem.
July 16, 2010
The complete formula is in the video description immediately below where you found the link to download the Excel file 🙂 Here it is again:
"For those who don't have the SEQUENCE function, you can use two formulas instead: Cell K5: =MIN( start date column ) + output of form control Cell L5: =K5+1 Copy L5 across columns as far as required."
Before inserting the new formula, select all of the cells containing the dates generated by the SEQUENCE function and delete them.
July 11, 2020
On the topic of the dashboard, firstly thank you very much for this tutorial. I really appreciate the step by step detail shared.
My question is on the field 'Duration', is there a formula that can be used to calculate this rather than being a manual input? For the completed days field, I understand that this would have to be a manual input.
Thanks very much
July 16, 2010