Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Alerts for Created (Date) Column

D Domine
D Domine ✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

I can't seem to find a way to set an alert if the Created Date changes.  This would essentially only alert me when a user filled out the web-form and not if someone changed the contents of the row.   I have an employee that needs to know when a new row is added, but doesn't need add'l updates when other employees massage the data.


Thanks in advance!    


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    How are the rows added?

    If by WebForm, add a check box column that is hidden and defaults checked when the form is submitted. Key the notification off that.

    If not, then add a check box column with a formula =1

    Make sure all rows have that formula. When a new row is added, it will see the formula and auto-fill.

    Key the notification off that.

    These two solutions may not be compatible, so you might need to two columns (the webform can populate the formula, only the result)


    Hope this helps.





This discussion has been closed.