# Combining ARRAYFORMULA and CONCATENATE

**URL:** <https://community.glideapps.com/t/combining-arrayformula-and-concatenate/13924>\
**Category:** Ask for Help\
**Created:** [August 13, 2020, 6:17am UTC](https://community.glideapps.com/t/combining-arrayformula-and-concatenate/13924 "2020-08-13T06:17:08Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kabookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kabookie/32/10994_2.png) [@kabookie](https://community.glideapps.com/u/kabookie)\
**Post date:** [August 13, 2020, 6:17am UTC](https://community.glideapps.com/t/combining-arrayformula-and-concatenate/13924/1 "2020-08-13T06:17:08Z")

</div>

I’m having trouble combining two different formulas and am not sure if I can. My goal is to use CONCATENATE to re-create a unique link to a user’s sales page and use ARRAYFORUMLA to populate the link down the sheet as new users are added.

First, I have CONCATENATE working fine: **=CONCATENATE(“[https://company.com/“,N2,”/store/product/39000.022.009](https://company.com/%22,N2,%22/store/product/39000.022.009)”)** where N2 is the cell where username is located. This results in a link to their sales page: [https://company.com/username/store/product/39000.022.009](https://company.com/username/store/product/39000.022.009)

Second, I am using this formula in Row 1 to successfully automatically fill the cells when a new user registers in the app.  
_={“Header Name"; ARRAYFORMULA(IF(A2:A\<\>“”,“data\_for\_cell”,“”))}_

But I can’t seem to figure out how to combine the two functions so that the sheet automatically will create the link AND populate at the same time. I tried this logical step but the nesting did not work:  
\*={“Header Name"; ARRAYFORMULA(IF(A2:A\<\>“”,\*\*_CONCATENATE(“[https://company.com/“,N2,”/store/product/39000.022.009")\*\*\*,"](https://company.com/%22,N2,%22/store/product/39000.022.009%22)***,%22)”))}_

Any extra brain power would be greatly appreciated 🤔

---

<div class="post-metadata">

**Author:** ![adelhammoud](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adelhammoud/32/5587_2.png) [@adelhammoud](https://community.glideapps.com/u/adelhammoud)\
**Post date:** [August 13, 2020, 6:32am UTC](https://community.glideapps.com/t/combining-arrayformula-and-concatenate/13924/2 "2020-08-13T06:32:01Z")

</div>

Better you use & instead of concatenate

“[https://company.com/"&N2:N&"/store/product/39000.022.009](https://company.com/%22&N2:N&%22/store/product/39000.022.009)"

---

<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:** [August 13, 2020, 7:49am UTC](https://community.glideapps.com/t/combining-arrayformula-and-concatenate/13924/3 "2020-08-13T07:49:49Z")

</div>

If you don’t need to see it in the sheets then you can make a template column to join it in Glide, else you can try Adel’s method.

---

<div class="post-metadata">

**Author:** ![kabookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kabookie/32/10994_2.png) [@kabookie](https://community.glideapps.com/u/kabookie)\
**Post date:** [August 13, 2020, 7:53pm UTC](https://community.glideapps.com/t/combining-arrayformula-and-concatenate/13924/4 "2020-08-13T19:53:24Z")

</div>

Thank you - If I use the template, then do I not need the ARRAYFORMULA? Will it fill as needed automatically? This may solve both problems.

---

<div class="post-metadata">

**Author:** ![adelhammoud](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adelhammoud/32/5587_2.png) [@adelhammoud](https://community.glideapps.com/u/adelhammoud)\
**Post date:** [August 13, 2020, 7:58pm UTC](https://community.glideapps.com/t/combining-arrayformula-and-concatenate/13924/5 "2020-08-13T19:58:21Z")

</div>

Yes, there is no need for arrayformula if you use template to join strings.

---

<div class="post-metadata">

**Author:** ![kabookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kabookie/32/10994_2.png) [@kabookie](https://community.glideapps.com/u/kabookie)\
**Post date:** [August 13, 2020, 8:03pm UTC](https://community.glideapps.com/t/combining-arrayformula-and-concatenate/13924/6 "2020-08-13T20:03:52Z")

</div>

Thank you!