Hi! I will explain a few things about what my goal is…
Table: Daily Report
Function: Every time an edit is made to the “Stores” table, a row is added to this table
Column 1: Key
Column 2: Today
Records the date of the edit
Column 3: Visitor
Records the name of the person who edited the row using this function…
LOOKUP(USEREMAIL(),“User Managment”,Email,“Full Name”)
Table: User Managment
Function: A list of users of the app
Column 1: Full name
Column 2: Email
Column 3: Last Store Visit
This is the column that I need a formula for
This formula must return the last date that each person edited the “Stores” table. Each person will have a different date. If user #1 edited “Stores” today, May 6th, but User #2 last edited the “Stores” table on April 15th, then the row should return May 6th in the Last Store Visit column for User #1, but April 15th for User #2. If User #2 were to then edit the table tommorow, May 7th, then the column would automatically update in his row to “May 7th”.
Is a function like this possible? I’ve tried unsuccessfully to use MAXROW(), but i’m also not very experienced with this function, so maybe i’m using it wrong.
I also tried to use SORT() and INDEX() together, to try to get the top value of a descending sorted list of the Daily Value table, but that didn’t work for me either.
Thank you very much in advance to whoever can help me out!