Audit Trail - Last Modified By Value + Copy A Row Flow
I’m building an audit trail to capture any changes made to my main sheet.
In my main sheet, I have a column for last modified date (type = modified date) and a column for last modified by ( type = modified by). I have a flow that is set to copy a row to the sheet “change log” when any field in that row is changed.
Problem: in sheet “change log”, the “last modified by” column is always recorded as “[email protected]”. I guess because this row is created by the automation flow in this sheet.
Question: Is there a way I can copy the “last modified by” column info from the main sheet instead?
yes I’m aware I can always go to main sheet to check cell history and see who changed it. But I’m trying to eliminate the manual work.
thank you all in advance
Help Article Resources
Check out the Formula Handbook template!