is it possible to list in the sheet the date of updating the sheet automatically?

Jacek Filip

is it possible to list in the sheet the date of updating the sheet automatically, is there any formula for it?

Purnima Gore

Hi

You could used the modified by column which is the has the date an time.

The issue I had with this is that you have to run the sort each time.

I created a report that automatically sorts

This seems to work so when you refresh the report it updates it to the item that was last modified.

Usually though there is a two way update feature on the report so you can add a line to the bottom, press save and it updates the source sheet but this is not working on this. Not sure why but at least this will give you a method.

Hope that helps.

ATB

Purnima

Jacek Filip

@Cierr Nice But i want to display only the update date of the entire sheet, not individual lines.It is possible ?