Combining ARRAYFORMULA and CONCATENATE

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”) 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

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”),""))}

Any extra brain power would be greatly appreciated :thinking:

Better you use & instead of concatenate

https://company.com/"&N2:N&"/store/product/39000.022.009"

1 Like

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.

1 Like

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.

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

3 Likes

Thank you!