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, pleaseVisit the Current Forums.
Feature Request: Comprehensive Notification Setting

We need the option to set our notifications to include ALL changes, not just the changes of others.
Right now if you subscribe to sheet notifications, the only way to get a full list of what changed is if you don't make any changes to the sheet yourself. Boooooo. Why can't I choose?
Currently, if you have notifications set up for you on a sheet - it will only send you information if the changes in the sheet were not made by you. You get an email once a day to tell you about everything on the sheet that changed - except what you did.
So, let's say you want to forward this email along to someone outside of your workgroup for their information, or your N+2 manager as an update. I can forward this along to them, but it won't contain ALL the information about what changed in the sheet if I made any changes.
Comments
-
J. Craig Williams ✭✭✭✭✭✭
Try a new user - if you have corporate IT, have them set up an alias for you. Set up the sheet's alerts using that user, but don't do anything else (no formulas or formatting or anything - just to be sure)
如果您正在使用gmail,你可以使用fake emails pretty easily that go to your regular Gmail account.
According to Gmail.
is the same as
but Smartsheet thinks they are different.
Hope this helps.
Craig
-
Brad Jones ✭✭✭✭✭✭
Craig,
Thanks for the workaround idea. LA suggested this too. It won't solve the problem exactly, however. I have 10 people updating the sheets, but many many people subscribing to the notifications of the sheets (like a news report from the project site). I want all users to get a full report of the changes.
Ideally, this would be an option you could set in the system so that you can choose between "ALL changes" and "Changes of others".
-
J. Craig Williams ✭✭✭✭✭✭
I see the problem and agree with your proposed solution. Seems like it won't do any harm.
If Corporate IT is involved, you could forward that dummy email to a group email distribution list.
Speaking of which, that could be done in Smartsheet with the Group function.
Add that as a feature request.
Craig
-
Dave D ✭
Are changes made regularly? You could build a report that shows all the rows that were changed in the last X days (or today) then turn on highlight changes to highlight the exact cells then send the report as a PDF on a recurring basis.
-
J. Craig Williams ✭✭✭✭✭✭
My first thought, Dave D, was this is brilliant.
Except for the number of columns (even with 10 "type" of sheets, the column names are unlikely to be the same (and I don't mean the ones that SHOULD be the same but aren't because of, well just because). And then you end up with a quilt work pattern of rows even 2 sheets with two different purposes (and thus 2 different column names) would at best look something like this.
[common columns][changes from sheet group 1][no common columns ]
[common columns][changes from sheet group 1][no common columns ]
[common columns][changes from sheet group 1][no common columns ]
[common columns][no common columns ][changes from sheet group 2]
[common columns][no common columns ][changes from sheet group 2]
[common columns][no common columns ][changes from sheet group 2]
But, you could create one report per sheet type.
Reports require sharing - and I prefer to give permissions on need-to-know basis.
Especially sensitive financial and personal data.
It also keep the clutter down for the end-user.
So not quite brilliant, but certainly exceptional. And something in the back of my mind says "there's more here..."
Craig
-
Brad Jones ✭✭✭✭✭✭
Thank you all for your comments and input. The scenario is that I have a project where the PM and Site Management need updates from the team activity on a daily basis. Other speicalists offsite also need to have these updates. So, the frequency is 'daily'.
My desire is to have something that does not require me to do anything manually other than set up the notificaitons once. If it were an option to "ignore My Updates" or "Receive All Changes" this would be great. At the moment a filter imposed by the design (likely for the convenience of those burdened with administrating too many sheets) is in the way of the information sharing I wish to achieve.
-
Brad Jones ✭✭✭✭✭✭
Any word from the Smartsheet staff on this one? It's really a pain for me.
-
Kennedy Stomps Employee
Hi Brad-- I can add your vote for this change to the Notification functionality! I know that we are soliciting feedback for overall improvements to Notifications right now as part of our Conditional Notifications projects so I will also pass this feedback on to that PM directly.
-
Gwyneth C ✭✭✭✭✭✭
Hi All,
As mentioned, we're actively working on this feature. If you have ten minutes to spare, we'd love to get your participation in a usability study we're running.
For more information, see this announcement:
https://community.smartsheet.com/announcement/weigh-smartsheets-next-strategic-feature
-
Brad Jones ✭✭✭✭✭✭
Did not see this feature in the test bed. But we only went through 10 exercises. Will this update include the ability to see all changes, and not just the changes of others?
Categories
A comma is needed between each range to sum.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107871,"type":"question","name":"Want to compare values in 3 columns to return a value in 4th column","excerpt":"Trying to sum up all many active projects are over due. Can add up my active projects with formula: =if(and(type@row=\"project\",status@row=\"in progress),1,0) but now I want to add the criteria of target completion date is late. Tried the following but get the dreaded \"unparseable\" message... =if((and(\"target completion…","snippet":"Trying to sum up all many active projects are over due. Can add up my active projects with formula: =if(and(type@row=\"project\",status@row=\"in progress),1,0) but now I want to add…","categoryID":322,"dateInserted":"2023-07-20T17:34:51+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T17:52:55+00:00","insertUserID":139408,"insertUser":{"userID":139408,"name":"BJTidi","url":"https:\/\/community.smartsheet.com\/profile\/BJTidi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T17:53:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":139408,"lastUser":{"userID":139408,"name":"BJTidi","url":"https:\/\/community.smartsheet.com\/profile\/BJTidi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T17:53:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3379751266,"url":"https:\/\/community.smartsheet.com\/discussion\/107871\/want-to-compare-values-in-3-columns-to-return-a-value-in-4th-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107871\/want-to-compare-values-in-3-columns-to-return-a-value-in-4th-column","format":"Rich","lastPost":{"discussionID":107871,"commentID":386225,"name":"Re: Want to compare values in 3 columns to return a value in 4th column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386225#Comment_386225","dateInserted":"2023-07-20T17:52:55+00:00","insertUserID":139408,"insertUser":{"userID":139408,"name":"BJTidi","url":"https:\/\/community.smartsheet.com\/profile\/BJTidi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T17:53:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T17:53:25+00:00","dateAnswered":"2023-07-20T17:47:21+00:00","acceptedAnswers":[{"commentID":386222,"body":"
I am not sure I am interpreting your request correctly. Is this what you are trying to accomplish?<\/p>
=IF(AND(type@row=\"project\", status@row=\"in progress\", [target completion date]@row < TODAY()), 1, 0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107853,"type":"question","name":"Need help with a date formula to always return a Friday date.","excerpt":"I see there is a standard formula and you just need to change the last number depending on the day of the week. Date@row - WEEKDAY(Date@row) + 2 The \"+ 2\" can be modified to pick a different day of the week. 1 = Sunday, 3 = Tuesday, etc. Here is the formula on my sheet but is shows #unparseable. =Customer Date Needed@row -…","snippet":"I see there is a standard formula and you just need to change the last number depending on the day of the week. Date@row - WEEKDAY(Date@row) + 2 The \"+ 2\" can be modified to pick…","categoryID":322,"dateInserted":"2023-07-20T13:20:08+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T18:36:28+00:00","insertUserID":163628,"insertUser":{"userID":163628,"name":"Jose G.","title":"Planner","url":"https:\/\/community.smartsheet.com\/profile\/Jose%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:39:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147819,"lastUser":{"userID":147819,"name":"MichaelTCA","url":"https:\/\/community.smartsheet.com\/profile\/MichaelTCA","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!naloP9MDFDs!u7kqZ3eepDs!ZlXWVSCN_A6","dateLastActive":"2023-07-20T18:34:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":48,"score":null,"hot":3379741596,"url":"https:\/\/community.smartsheet.com\/discussion\/107853\/need-help-with-a-date-formula-to-always-return-a-friday-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107853\/need-help-with-a-date-formula-to-always-return-a-friday-date","format":"Rich","lastPost":{"discussionID":107853,"commentID":386244,"name":"Re: Need help with a date formula to always return a Friday date.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386244#Comment_386244","dateInserted":"2023-07-20T18:36:28+00:00","insertUserID":147819,"insertUser":{"userID":147819,"name":"MichaelTCA","url":"https:\/\/community.smartsheet.com\/profile\/MichaelTCA","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!naloP9MDFDs!u7kqZ3eepDs!ZlXWVSCN_A6","dateLastActive":"2023-07-20T18:34:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T17:56:13+00:00","dateAnswered":"2023-07-20T13:28:45+00:00","acceptedAnswers":[{"commentID":386145,"body":"
If your column name contains spaces, you will need to enclose it in square brackets.<\/p>
=[Customer Date Needed]@row - WEEKDAY([Customer Dated Needed]@row) + 6<\/p>"},{"commentID":386152,"body":"
Column names containing a space, number, and\/or special character need to be wrapped in [square brackets]<\/strong> when referenced in a formula.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">