The design of my user onboarding flow does not allow me to capture the user created date through typical means. I need this so I can set up a drip email campaign for my users. I think grabbing the first login data from App:Logins and stuffing it into a field in the profile sheet is the way to go. B…

I use it all the time. Here you go. Add this to any column in your users sheet given that Column A is the email address column. ={"Joined";ArrayFormula(if(len(A2:A),text(VLOOKUP(A2:A,{'App: Logins'!B2:B,'App: Logins'!A2:A},2,0),"m/d/yyyy"),""))}

Sweet! Thanks so much Robert and great explanation @ThinhDinh Sometimes I just can’t wrap my head around complex formulas. I think part of it is that the “IDE” is a tiny little formula bar :slight_smile:

@Robert_Petitto using this would be great for giving users a 7 or 14 day trial of an app before asking them to pay.

[image] Robert_Petitto: ={"Joined";ArrayFormula(if(len(A2:A),text(VLOOKUP(A2:A,{'App: Logins'!B2:B,'App: Logins'!A2:A},2,0),"m/d/yyyy"),""))} After creating the joined column, I tried to create a “Days Joined” column but I have been wrestling with errors, do you have a formula in your back po…

As in the difference between today and the join?

I’d use the glide data editor for that. Subtract joined date from today: [image] new Date-time Math Glide FAQs The Math column can now do math with date/times. In particular: Subtracting two date/times produces a duration, which is a number and is measured in days, lik…

I would do that but I would like to access the data externally to run a drip email campaign.

={"Date Difference";ARRAYFORMULA(IF(A2:A<>"",DATEDIF(A2:A,TODAY(),"D"),"")} This function checks if your A column, assuming that is where you store your dates from the previous step, is not empty. If it is indeed not empty then calculate the difference in days between that date and today.

Hmmm… I am getting the same “formula parse error” from my personal attempt at this. [image]

You’re missing the } at the end of the formula.

Formula to Calculate User Created Date from App:Logins?

Ask for Help

Robert_Petitto October 22, 2020, 7:56pm 9

I’d use the glide data editor for that. Subtract joined date from today:

Topic		Replies	Views
User date creation Ask for Help	12	106	January 4, 2026
Tabs : Show Updates Feature Requests	13	613	July 16, 2021
User specific data using a date formula in google sheet, input in glide Ask for Help	15	579	February 15, 2023
Date Signed Up not being captured at sign up Report a Bug	4	301	July 21, 2022
Query and Login - Error Ask for Help	5	344	January 16, 2020

Formula to Calculate User Created Date from App:Logins?

Related topics