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