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(““,N2,”/store/product/39000.022.009”) where N2 is the cell where username is located. This results in a link to their sales page:

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(““,N2,”/store/product/39000.022.009")***,"”))}

Any extra brain power would be greatly appreciated :thinking:

Better you use & instead of concatenate"&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.


Thank you!