Latest Modified Date/Modified by Formula


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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!