Hi! I will explain a few things about what my goal is…
Table: Stores
Table: Daily Report
Function: Every time an edit is made to the “Stores” table, a row is added to this table
Column 1: Key
UNIQUEID()
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!
Solved! Go to Solution.
Got it. Can you please make the column a VC.
User | Count |
---|---|
43 | |
28 | |
26 | |
16 | |
11 |