ArrayFormula Not incrementing

Hi Guys,
I am struggling with getting the formula to behave as I want it to, and would really appreciate any help you can offer please?
I have an array formula in a spreadsheet but it does not increment the values through each of the rows although it does populate all rows;

the formula is
={“Zulu Date”;ARRAYFORMULA(IF(A2:A<>“”,CONCATENATE(E2&“/”&F2),“”))}

The data columns are
Event, Start Date, End Date, Zulu Date, Zulu Start, Zulu End

Here is a link to example spreadsheet

Many Thanks


={"Zulu Date";ARRAYFORMULA(IF(A2:A<>"",E2:E&"/"&F2:F,""))}

It should have been E2:E instead of E2 and F2:F instead of F2, also you should do it like the way above instead of concatenating.

Many thanks that works great
Thank you


1 Like