Why does cell history show user updating cell?

Cory Strischek

"View cell history" for certain cells in a collection of rows shows a user updating those cells at 8:43am.

In Activity Monitor, I see that user's action at 8:43am was "Row hierarchy changes." So, she didn't actually update the cell contents, which is just a formula displaying red, green or yellow status if certain dates are X days in the future, etc.

Is the history just saying that she was the first person to collapse or expand a row that contained a time-based change?

Genevieve P.

Hi @johncory

Does the status column with the colours use the TODAY function? If so, it's possible that the user accessing the sheet helped the sheet recognize what day "today" is, thus updating the formula and the status colours.

Our Help Center has an article that goes through all the way the TODAY function can be updated (see here).

Hope this helps!

Genevieve

Genevieve P.

Hi @johncory

Yes, exactly: Smartsheet will update all instances of the TODAY function in a sheet to the current date when you open the sheet and save it.

It sounds like that's what this user did, which therefore updated the formula!

Genevieve P.

Hi @johncory

Does the status column with the colours use the TODAY function? If so, it's possible that the user accessing the sheet helped the sheet recognize what day "today" is, thus updating the formula and the status colours.

Our Help Center has an article that goes through all the way the TODAY function can be updated (see here).

Hope this helps!

Genevieve

Cory Strischek

Yes, the formula does use the TODAY function. The sheet helped the sheet or the "user save helped the sheet" by folding/unfolding hierarchy and saving?

Thanks

Genevieve P.

Hi @johncory

Yes, exactly: Smartsheet will update all instances of the TODAY function in a sheet to the current date when you open the sheet and save it.

It sounds like that's what this user did, which therefore updated the formula!