Cell last update timestamp from api

Tidhar

Hi,

Is there a way to get a cell last update datetime from api, that is not using get_cell_history?

I'm asking because get_cell_history is an expensive call (takes 10 tokens).

Georgie

Hi @Tidhar,

I found this thread in the API/Developers Community which has a suggestion: Smartsheet Cell History check.  

If the above thread doesn’t help, I’d recommend creating your own post on the Stack Overflow site with the ‘smartsheet-api’ tag to see if any users have additional suggestions. You can also find more information on the Smartsheet API on the Smartsheet Developers Portal.

Hope that helps!

Georgie

Lee Joramo

I am not aware how to get a last modified timestamp of a cell without calling the Cell's History and incurring the 10 token usage. I suggest few strategies:

1. Rows provide a last modified timestamp. You might be able to reduce the number of Cell Histories you need to check by pre-screening them based on the Rows Modification.

2. You can setup webhooks to trigger whenever a column is modified. Then trigger an API to update a companion column with the modification date for the watched cell.

3. While API Tokens are limited to 300 calls per minute, you can use as many Tokens as you want. So you can create a system to alternate between a number of tokens and effectively remove the rate limit.

The last option feels like cheating. I was certainly concerned I would get in trouble with Smartsheet when I started do this, but my Smartsheet reps said it was Ok. And in fact, at the Smartsheet Engage Conference earlier this month this was officially suggested during a session of using the API.

James Christiansen

I would really like to have the ability to use the last updated time of a cell (rather than the row) in a formula. As in "time to completion= (last updated "assigned date")-"date completed"

SSFeatures

Hi @James Christiansen,

I recommend creating a Product Feedback Request, so that other people can upvote this idea.

I think that having a formula for the last update time of a cell would be super useful for a lot of people. In fact, I answered a question earlier today about this same exact issue.

Best!

James Christiansen

@SSFeatures

Thanks, I have made the submission.