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
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!
Comments
-
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.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives