# ArrayFormula Not incrementing

**URL:** <https://community.glideapps.com/t/arrayformula-not-incrementing/16919>\
**Category:** Ask for Help\
**Created:** [October 8, 2020, 2:51pm UTC](https://community.glideapps.com/t/arrayformula-not-incrementing/16919 "2020-10-08T14:51:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Turner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_turner/32/578_2.png) [@Robert\_Turner](https://community.glideapps.com/u/Robert_Turner)\
**Post date:** [October 8, 2020, 2:51pm UTC](https://community.glideapps.com/t/arrayformula-not-incrementing/16919/1 "2020-10-08T14:51:04Z")

</div>

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

> **[ArrayFormula not Incrementing values](https://docs.google.com/spreadsheets/d/1zWbk3T7RhX-9akKq6MW7c0A2CCAl5W7b2gjr9NZZR4w/edit?usp=sharing)**
>
> Sheet1
> 
> Event,Start Date,End Date,Zulu Date,Zulu Start,Zulu End
> test event 1,Monday, September 28, 2020, 6:00: PM,Monday, September 28, 2020, 7:00: PM,20200928T180000Z/20200928T190000Z,20200928T180000Z,20200928T190000Z
> test event 2,Monday, September...

Many Thanks

Rob

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 8, 2020, 3:00pm UTC](https://community.glideapps.com/t/arrayformula-not-incrementing/16919/2 "2020-10-08T15:00:22Z")

</div>

```
={"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.

---

<div class="post-metadata">

**Author:** ![Robert\_Turner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_turner/32/578_2.png) [@Robert\_Turner](https://community.glideapps.com/u/Robert_Turner)\
**Post date:** [October 8, 2020, 3:48pm UTC](https://community.glideapps.com/t/arrayformula-not-incrementing/16919/3 "2020-10-08T15:48:46Z")

</div>

ThinhDinh,  
Many thanks that works great  
Thank you

Rob