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

Brad Jones
Brad Jones ✭✭✭✭✭✭
edited 12/09/19 inArchived 2016 Posts

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
    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.

    [email protected]

    is the same as

    [email protected]

    but Smartsheet thinks they are different.

    Hope this helps.

    Craig

  • Brad Jones
    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
    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

  • 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
    J. Craig Williams ✭✭✭✭✭✭
    edited 04/23/16

    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.

    报告需要分享,我喜欢给每missions 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
    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
    Brad Jones ✭✭✭✭✭✭

    Any word from the Smartsheet staff on this one? It's really a pain for me.

  • 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
    Gwyneth C ✭✭✭✭✭✭
    edited 09/16/16

    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
    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?

This discussion has been closed.
Thank you, as always I was trying to make it too hard!!!!<\/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":106975,"type":"question","name":"Case sensitivity when using data mesh","excerpt":"I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including manager's email. The DataMesh is keying of of the common field of User ID. We noticed that for many of the nurses the match didn't work and also…","snippet":"I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including…","categoryID":343,"dateInserted":"2023-06-27T19:39:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T20:09:07+00:00","insertUserID":114017,"insertUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":114017,"lastUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3375793110,"url":"https:\/\/community.smartsheet.com\/discussion\/106975\/case-sensitivity-when-using-data-mesh","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106975\/case-sensitivity-when-using-data-mesh","format":"Rich","lastPost":{"discussionID":106975,"commentID":382692,"name":"Re: Case sensitivity when using data mesh","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382692#Comment_382692","dateInserted":"2023-06-27T20:09:07+00:00","insertUserID":114017,"insertUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T20:09:23+00:00","dateAnswered":"2023-06-27T20:09:03+00:00","acceptedAnswers":[{"commentID":382691,"body":"

Perfect. Thank you so much!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":106971,"type":"question","name":"Using SUMIFS Formula","excerpt":"Needing help writing a SUMIFS formula! I have tried a few ways, but just get errors. =SUMIFS({budget}, {Type}, \"AMR\", {leadership}, \"Truttmann\")) I would like to have the sum of the budget if the type is AMR and the leadership is Truttmann. I have multiple types and leaderships that I would be using this for. Thanks!","snippet":"Needing help writing a SUMIFS formula! I have tried a few ways, but just get errors. =SUMIFS({budget}, {Type}, \"AMR\", {leadership}, \"Truttmann\")) I would like to have the sum of…","categoryID":322,"dateInserted":"2023-06-27T18:45:22+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T20:20:13+00:00","insertUserID":162642,"insertUser":{"userID":162642,"name":"jtomeaCH","title":"ISG Support Manager","url":"https:\/\/community.smartsheet.com\/profile\/jtomeaCH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T20:31:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162642,"lastUser":{"userID":162642,"name":"jtomeaCH","title":"ISG Support Manager","url":"https:\/\/community.smartsheet.com\/profile\/jtomeaCH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T20:31:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":26,"score":null,"hot":3375791135,"url":"https:\/\/community.smartsheet.com\/discussion\/106971\/using-sumifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106971\/using-sumifs-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106971,"commentID":382695,"name":"Re: Using SUMIFS Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382695#Comment_382695","dateInserted":"2023-06-27T20:20:13+00:00","insertUserID":162642,"insertUser":{"userID":162642,"name":"jtomeaCH","title":"ISG Support Manager","url":"https:\/\/community.smartsheet.com\/profile\/jtomeaCH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T20:31:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T20:19:39+00:00","dateAnswered":"2023-06-27T19:59:16+00:00","acceptedAnswers":[{"commentID":382688,"body":"

Double check your cross sheet references. Make sure they are all single columns by clicking on the appropriate column header.<\/p>


<\/p>

When doing this, give the sheet a little time to load before selecting the column. Sometimes moving too fast allows you to select a column header before the sheet fully loads in the creator window. Then when the sheet does finally completely load in, the selection automatically reverts to the home cell (top right corner). This happens to me quite a bit when I am in a hurry.<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"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":[]}">

Trending Posts