Return user name for latest date created

Kathy Rogers

Hello,

I have a sheet that populates from entries by a form. I would like a formula that tells me the name of the user on the very latest entry. I've tried various combinations but can't seem to get the right one that returns the users name. Could someone please assist me?

I have a User Column, Created Column (auto generated).

Thanks

RossL

@Kathy Rogers

You can do something along these lines

=JOIN(COLLECT(NameColumn1:NameColumn1, DateColumn1:DateColumn1, MAX(DateColumn1:DateColumn1)))

RossL

@Kathy Rogers

You can do something along these lines

=JOIN(COLLECT(NameColumn1:NameColumn1, DateColumn1:DateColumn1, MAX(DateColumn1:DateColumn1)))

Kathy Rogers

Thanks Ross. That works perfectly.