Is a cell update (via a formula) considered a row update for Notifications?

jsowell56766

I am trying to determine if a cell changing via a formula is considered an update to start a notification. 

I have a cell that will change status based on another cell that calculates the number of days until expiration from today's date.

I guess the real question is what flags the system as an update; the values of a cell being physically changed from user input (say from 1 to 2) or a formula that would calculate the value being changed (from 1 to 2 based on today's date)

Andrée Starå

Hi,

Both cases would count as an update.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

jsowell56766

Thanks! I think I now have a way to send notifications to non users via alerts when a status changes based on the current date. No updates needed.

 

On the today function- Do you know if the sheet has to be opened and saved for the date to change?

J. Craig Williams

If the displayed value of a cell changes, the row has been updated. When the Sheet is saved, the [Modified] timestamp column is updated (whether it is displayed, or not).

The only changes I can think of that do not trigger a change are updates to Comments or Attachments.

Craig

 

Andrée Starå

Happy to help!