Unpivot and analyse data

that is amazing, thank you for all your help

unfortunately I still have some issues implementing this to my data set

as mentioned the dataset contains many more columns which are not required for this analysis
when I implemented the formula to the full sheet, it chewed up my resources and made my PC unusable

so I used 'choosecols' to replicate the columns from main dataset into a new sheet, and applied the formula there
I think this is required since the dataset will be continually updated
The formula executes in seconds this way

so when I apply formula to those columns, it appears accurate for logged, assigned is throwing a #num error and complete looks accurate (since complete dates have not been recorded completely)
Carry-over is giving #calc error presumably because of the #num error on assigned

I will review my data to figure out where the #num error is arising

Screenshot 2024-05-14 211743.png

Thanks again