Latest Modified Date/Modified by Formula

Lori Khoury

Hello

I need help on a formula tracking when a particular person has modified a sheet.

I have 25 project plans that I am admin for. I need to find out when the last time the project manager updated their plan. I have the following formulas running against the Modified and Modified By column. However, I need to update the formula so that I can return the last time the sheet was modified by a particular person or have the formula exclude my email from the formula.

Last Date Modified

=MAX(COLLECT(Modified:Modified, Modified:Modified, ISDATE(@cell)))

Last Modified By

=INDEX(COLLECT([Modified By]:[Modified By], Modified:Modified, MAX(Modified:Modified)), 1)

Paul Newcome

You would add another range/criteria set within the COLLECT function looking at the [Modified By] column and the criteria being that specific email.