Sheets last modified time not updated

Naveen_123

I have changed data in the sheet but last modified time remains same,Please check and update.

Genevieve P.

Hi @Naveen_123

The Modified Date column will record a date when each row is modified, for that specific Row. That means if you update row 10, the date in row 10 will change, but none of the other dates will update. Is this what you were looking to do?

Here's more information:

https://help.smartsheet.com/articles/2480241-column-type-reference#toc-system

Cheers,

Genevieve

Naveen_123

No, rows modified date were changed but Sheet modified date(Last update) not changed.Last updated time in the Smartsheet support sheet row was 05/29/23 but last updateed time out side the sheet shows 05/27/23

Genevieve P.

Hi @Naveen_123

Ah! Thank you for clarifying, I understand what you mean now.

What happens if you re-fresh the page, or if you log out then log back in again?

Naveen_123

It works when I refresh the page, but when I receive the same response through the API, the last updated time is not coming correctly.

https://api.smartsheet.com/2.0/sheets?modifiedSince=2023-05-26T14:05:00Z

After re-fresh page , in Smartsheet support sheet Last modified time shows 7:46 IST(check my system time) but last modified time in the API shows 14:02:11 GMT(7:32 pm) , It takes more than 2 hours to update in the API results, Please check and update

Genevieve P.

Hi @Naveen_123

I'm unable to replicate what you're seeing; as long as I've saved the sheet to ensure that the change has been recorded, then when using GET Sheet with the API the Modified Time is the same as the time showing in the Sheets folder.

I will note that the "1 minute ago" will stay saying "1 minute ago" until you re-fresh the page again. The timer isn't live - it updates when you update the browser tab.

Is it possible that you had not refreshed the browser again after your API call?

afarias

when is this bug getting updated?