Notifications for Contact List Column Option

Just wondering if the notification for contact list within a column setting has been resolved and we can now get notifications when something has been assigned to us?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@kdashnaw

    Yes, you can set a Notification to send to a Contact in a Contact Column in an Automated Workflow and it will send an email alert (as long as their personal settings allow this) as well as a notification within the Smartsheet App. See:Select your recipients

    There have been no recent incidents reported where these types of workflows were not sending out (see ourStatus Pagefor any reports like this).

    If I've misunderstood your question, can you post screen captures of your sheet and current set-up, as well as a detailed explanation of what you would like to happen? (But please block out sensitive data).

    Thanks,

    Genevieve

  • @Genevieve P.- thank you for the quick response.


    I made an automated workflow, as well as made sure the contacts in the cell had their notifications turned on. No one has received a notification as of yet and we have triggered the workflow/changed things around several times. Can you assist? Maybe I am writing the workflow wrong?


    image.png


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@kdashnaw

    I can see that the Workflow is alerting you to the potential issue in the "Alert Someone" box. Do you see where it says "some recipients may not get notified"?

    If your users aren't shared to the sheet, you may need to adjust your sheet's Permission Settings to allow alerts to send out to email addresses that aren't shared. Click the underlined bit of that message and it should take you right to that setting to change it! See:控制是谁通知警报和请求

    If you have the right settings here, it may be that the automated emails are being sent to their Junk mail. Here's an article with more information:Issue: Email Not Received from Smartsheet

    Cheers,

    Genevieve

  • Thanks,@Genevieve P.

    Everyone in the sheet I shared has access to the entire sheet and workspace, but I did change the sheet permission setting to 'unrestricted' to see if that helps.

    No one has received anything in their junk folder either, I made sure everyone checked.

    Just frustrated because I made a workflow and we need these alerts, but it seems like no one is able to get them :(

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@kdashnaw

    I completely understand your frustration, especially because your workflow is set up correctly: when a new row is added or a cell is changed from one person to another (and then the sheet is Saved), the workflow should trigger and send an email to the user specified in that cell.

    There are a few other things we can check:

    • If you're testing this by adding your own contact to the cell, have you adjusted your Personal Notification Settings to allow alerts to send to you, even if you're the one who made the change?
    2022-03-25在屏幕截图2.13.51 PM.png
    • Are the users receiving an alertwithin Smartsheetin the bell icon? (This indicates that the workflow is running, the issue has to do with how the email is received)
    • If they are receiving the alert IN Smartsheet, has your IT department added all the Smartsheet domains to their Safe Sender list? (See:All email appears to be blocked)

    Cheers,

    Genevieve

  • Hi@Genevieve P.


    These are my personal settings:

    image.png

    The others in the assigned to column have theirs as the same.


    Are the users receiving an alertwithin Smartsheetin the bell icon? (This indicates that the workflow is running, the issue has to do with how the email is received)

    ^No. No alerts are being received in SmartSheet itself which is weird.


    We are able to get SmartSheet emails, because every time someone shares a new sheet or workspace or sends and invite, we receive those in our inboxes. So I don't think it is that...

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@kdashnaw

    Thank you! This narrows it down. It sounds like the workflow is either not being triggered at all, or that it can't find the correct Contact to send the alert to.

    Can you post 3 screen captures (blocking out sensitive data):

    • One that shows the contact column in the sheet with the circle icon next to each Contact
    • One that shows the Workflow in the Builder, identifying the last time it was Triggered

    Ex:

    Screen Shot 2022-03-25 at 2.46.07 PM.png
    • One of the sheet'sActivity Log(if you have access to it), showing the last time you made a change or inserted a new row with a Contact value

    谢谢!

    Genevieve

  • @Genevieve P.- looks like I fixed it for one sheet!

    Do you think if I duplicate the workflow on the sheet that is working it will be okay?

  • Genevieve P.
    Genevieve P. Employee Admin

    I'm glad you were able to get it working!

    Duplicating a workflow should create another fully working workflow, so you may see multiple alerts if you keep both active.

  • Sorry, I meant duplicating the workflow in another sheet, not the same sheet.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@kdashnaw

    There currently isn't a way to copy a workflow from one sheet and paste it in another. You can definitely try re-creating the workflow from scratch to see if a new workflow will work!

  • Okay, thank you for letting me know and for all your help!

Help Article Resources

@keesuri25<\/a> <\/p>

Your formula is working for me:<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

What type of column is YTD on your sheet? It needs to be a Date type column.<\/p>"},{"commentID":346398,"body":"

It looks like you have a minor syntax issue. Whenever you reference a column name that has a space, number, and\/or special character in it, you have to wrap the column name in square brackets whereas you wrapped the entire reference in square brackets. Try this:<\/p>

=COUNTIFS([Engagement Phase]:[Engagement Phase], \"COMPLETED\", [PoC End date]<\/strong>:[<\/strong>PoC End date], YEAR(@cell) = 2022)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-07 00:22:30","updateUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-07T00:19:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":96311,"type":"question","name":"INDEX \/ MATCH Formula Question","excerpt":"Hello, I am missing something with executing this formula. This is my first time trying to apply to my sheet. I can only successfully return a #Unparseable error. 😥 Would appreciate any guidance you can provide. Formula: =INDEX({CI Weight}), MATCH([Task Name]@row, {Project Name}, 0) Goal: Pull in ranking (CI Weight) from…","categoryID":322,"dateInserted":"2022-10-06T17:01:23+00:00","dateUpdated":null,"dateLastComment":"2022-10-06T23:25:11+00:00","insertUserID":134324,"insertUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T23:22:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":134324,"lastUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T23:22:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":48,"score":null,"hot":3330178594,"url":"https:\/\/community.smartsheet.com\/discussion\/96311\/index-match-formula-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96311\/index-match-formula-question","format":"Rich","lastPost":{"discussionID":96311,"commentID":346402,"name":"Re: INDEX \/ MATCH Formula Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346402#Comment_346402","dateInserted":"2022-10-06T23:25:11+00:00","insertUserID":134324,"insertUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T23:22:23+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LKAW8HFTGVXC\/index-match-question.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"INDEX MATCH question.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-06T20:52:07+00:00","dateAnswered":"2022-10-06T20:47:41+00:00","acceptedAnswers":[{"commentID":346374,"body":"

Remove the ) after CI WEIGHT<\/p>"},{"commentID":346375,"body":"

My hero!! Muchas gracias, @Michael Culley<\/a> ! 🤩<\/span>🤩<\/span><\/p>"},{"commentID":346400,"body":"

If you want it to only apply to parent rows then it would look more like this:<\/p>

=IF(COUNT(CHILDREN([Task Name]@row)) <> 0, <\/strong>INDEX({CI Weight}, MATCH([Task Name]@row, {Project Name}, 0)))<\/strong><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-06 20:52:07","updateUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T23:22:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":96312,"type":"question","name":"Can I use the Countif function to count the amount of times one column is greater than another?","excerpt":"For example, in my Smartsheet I have two columns that I would like to compare data. \"Sprinkler Head Count (Estimated)\" versus \"Sprinkler Head Count (Actual).\" I would like to count how many times in my sheet where the Actual head count is greater than the Estimated head count. Any ideas how we can achieve this? Thanks in…","categoryID":322,"dateInserted":"2022-10-06T17:10:54+00:00","dateUpdated":null,"dateLastComment":"2022-10-06T17:16:52+00:00","insertUserID":151299,"insertUser":{"userID":151299,"name":"lcain","url":"https:\/\/community.smartsheet.com\/profile\/lcain","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T20:25:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145151,"lastUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AItbvmniEdReOVTwaHHrhgrOiwux3krYT43KIqrvf5FW=s96-c","dateLastActive":"2022-10-07T00:06:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3330154666,"url":"https:\/\/community.smartsheet.com\/discussion\/96312\/can-i-use-the-countif-function-to-count-the-amount-of-times-one-column-is-greater-than-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96312\/can-i-use-the-countif-function-to-count-the-amount-of-times-one-column-is-greater-than-another","format":"Rich","lastPost":{"discussionID":96312,"commentID":346312,"name":"Re: Can I use the Countif function to count the amount of times one column is greater than another?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346312#Comment_346312","dateInserted":"2022-10-06T17:16:52+00:00","insertUserID":145151,"insertUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AItbvmniEdReOVTwaHHrhgrOiwux3krYT43KIqrvf5FW=s96-c","dateLastActive":"2022-10-07T00:06:50+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XULU5EB0Y7VE\/estimate-v-actual.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Estimate v Actual.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-06T17:15:39+00:00","dateAnswered":"2022-10-06T17:14:49+00:00","acceptedAnswers":[{"commentID":346310,"body":"

create a checkbox column with this formula: <\/p>

=if(Sprinkler Head Count (Actual) >Sprinkler Head Count (Estimated),1,0)<\/p>

Then you can do a countif statement counting the checkboxes: =countif([checkbox column]:[checkbox column],1)<\/p>"},{"commentID":346312,"body":"

@lcain<\/a> <\/p>

I'm not sure if it can be done with a single formula. Here's what I would do.<\/p>

Create a helper column that's a checkbox column called something like \"Sprinkler (helper)\". Write this formula into it:<\/p>

=IF([Sprinkler Head Count (Actual)]@row>[Sprinkler Head Count (Estimated)]@row, 1)<\/p>

Then hide that column since you don't need to look at it on your sheet. Then in the column you want the count use this formula:<\/p>

=COUNTIF([Sprinkler (helper)]:[Sprinkler (helper)], 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-06 17:15:39","updateUser":{"userID":151299,"name":"lcain","url":"https:\/\/community.smartsheet.com\/profile\/lcain","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T20:25:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">