Forum

Notifications
Clear all

Sequence formula from How to Build Dynamic Excel Gantt Charts not working in my Microsoft® Excel® for Microsoft 365 MSO

2 Posts
2 Users
0 Reactions
256 Views
(@terry_tewell)
Posts: 1
New Member
Topic starter
 

I was attempting to replicate the Project tracking video and newsletter. Everything worked fine until I got to the Sequence formula. I cut and pasted the formula into the first cell for the dates. When it executes, I get 00 Jan. There are no January dates in my start or end date cells.  Also, it does not save the formula just the resulting value.

 


 
Posted : 27/03/2026 12:27 am
Riny van Eekelen
(@riny)
Posts: 1441
Member Moderator
 

@terry_tewell

I corrected your file up to 6:25 into the video. Note that you had expanded the structured table to include the (dynamic array) header row. You may not use dynamic array functions inside structured tables. That caused the odd header and all the spill errors below it.

Note that the "Gantt" functionality of the colored grid resides outside the structured table. See if you can pick-up the tutorial from here.


 
Posted : 27/03/2026 1:01 am
Share:
0