Welcome!

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

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)

Find more posts tagged with

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Auto-populate an email into a form to reduce error
Is it possible to auto-populate an email domain in a field where people are asked to enter their email address? For example, I would like users to only have to type their name, without needing to enter anything after the “@” symbol, to reduce the chance of personal email addresses being entered.
Suddenly View Only on all Workspaces and Sheets I own
This discussion was created from comments split from: I am an editor on a smartsheet but can't edit the sheet.
Sharing with Editors outside our company
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…