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


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

Answers

  • Purnima Gore
    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

    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

    https://www.cierr.com

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!