Loving Glide
I am quite OK now with the having the email addresses going from App logins automaticaly (no idea how this works!) to sheet one and creating a new line for each new subscriber. I have an app that now has abour 35 columns and is getting a bit difficult to work with.
Is it possible to have the email address from the App logins go to sheet two as well ?
Thanks
Of course, it is possible with this formula:
= ARRAYFORMULA (‘App: Logins’! B: B)
App: Logins is the sheet where your session login is, select the column where the email addresses are located.
You can also use it with more than two columns to a different spreadsheet, just select the range of columns, for example:
= ARRAYFORMULA (‘App: Logins’! B: Z)
1 Like
To add to what Mauricio has said, it’s possible to create an array of only columns you want to. It would look like.
=ARRAYFORMULA({'App: Logins'!A:A,'App: Logins'!C:C,'App: Logins'!Z:Z})
You can throw an IF into that formula as well to check if the row is filled with the data.
Thanks Robert
I’ve watched your video once - I need to watch it again - and then play with it !
Mike