Last update Formula (Sheet Summary)

Luis Rosario

I need to make a formula that identifies the last modified date on my sheet

Genevieve P.

Hi @Luis Rosario

The way I would to this is to add the System Modified Date column to the sheet. Then in your Sheet Summary you can use the following formula to return the MAX date, or oldest, most recent date:

=MAX(Modified:Modified)

Keep in mind that this would need to be put in Date type of Summary Field.

Let me know if this works for you!

Cheers,

Genevieve

Luis Rosario

Tks!!!!!

Genevieve P.

Hi @Luis Rosario

The way I would to this is to add the System Modified Date column to the sheet. Then in your Sheet Summary you can use the following formula to return the MAX date, or oldest, most recent date:

=MAX(Modified:Modified)

Keep in mind that this would need to be put in Date type of Summary Field.

Let me know if this works for you!

Cheers,

Genevieve

Luis Rosario

Tks!!!!!