Combining ARRAYFORMULA and CONCATENATE

Ask for Help
1

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:

2

Better you use & instead of concatenate

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

3

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.

4

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.

5

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

6

Thank you!