Respected Ma'am
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.
Best Regards
asad
Hi Asad,
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.
Mynda
Hi Mynda,
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
Melanie
Hi Melanie,
Welcome to our forum! In future, please start a new topic for a new question.
You can calculate the duration by adding completed days and days remaining to the start date. It would be a simply sum to add the 3 cells together.
Mynda
