Dynamic View Comments notifications for DV users without sheet access
Hi Everyone - i know this has been asked before but having trouble finding out if/when this might be fixed and i couldn't respond to the thread to ask...
We are trialling Dynamic View and have set up some profiles or "view" with comments enabled. We've found out you can tag someone in the comments in DV (although it doesn't auto-fill the contact like in the sheet) who is shared to the sheet and they will receive a notification but it will direct them to the sheet rather than DV. Someone who is not shared to the sheet will not receive a notification, but can still reply in DV - is there a fix in progress to look into sending a notification to non shared person with a link to DV?
We want to enable non sheet users to be able to have a both way conversation in the comments but also be notified and direct them to their DV to be able to reply. It seems a bit pointless if they have to go in and manually check for responses.
TIA
Answers
-
Genevieve P. Employee Admin
What about setting up a notification (in the sheet) withthe trigger setto when comments are added? That way your users don't have to @mention an email and you can put the direct URL to the Dynamic View in the subject of the alert.
Alerts can be sent out to users who aren't shared to the sheet, and youcan customize it (see here)to exclude the sheet link from the message if you'd like. Would that work for you?
Please also fill outthe Enhancement Request formto let the Product team know about your use-case and request.
Thank you!
Genevieve
-
Eva Murphy ✭✭
@Genevieve P.- how would you build a trigger in a workflow based on the addition of comments? Not finding a way to do that...
Thanks for your help!
-
Andrée Starå ✭✭✭✭✭✭
I hope you're well and safe!
Here's where you can find it.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅做我的帖子(s)帮助或回答你什么stion or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
BESP10 ✭✭✭✭✭✭
Hi guys, I am trying to figure this out, I added 4 comments to my sheet to test this out and I am not getting email notifications. Trying to set up communication with the dynamic view, is there something wrong with this setup?@Andrée Starå@Genevieve P.Thank you
-
Genevieve P. Employee Admin
Hey@BESP10
Can you check your personal settings to see if you have this box checked or not?
Cheers,
Genevieve
-
BESP10 ✭✭✭✭✭✭
Hi@Genevieve P.yes this is checked off, but I am not getting alerts when comments are added to the sheet? :-(
-
Genevieve P. Employee Admin
Hi@BESP10
Thanks for checking! I tested this same set up and received the notification.
Can you check to see if you received the alert in-app, in the bell notification, just not as an email?
-
BESP10 ✭✭✭✭✭✭
Hi@Genevieve P.this is my work flow, I just put a comment "test" on the discussion and I still am not getting any notification
what I am doing wrong>?
-
Genevieve P. Employee Admin
Hi@BESP10
When you say you're not getting a notification, do you mean as an Email, in the Application (bell icon), or both?
Is there any possibility that the row you added a comment on does not have the right criteria for the Condition Block? (E.g. the Project Manager name is spelled a little differently than what you have in the alert)?
-
BESP10 ✭✭✭✭✭✭
an email, and belll icon, nothing@Genevieve P., would it help I share my sheet with you?
-
Genevieve P. Employee Admin
Hi@BESP10
A screen capture of your underlying source sheet would be helpful, yes!Please point out the row that you left the comment on; we'll just want to ensure that the criteria in your workflow matches what you have in the row.
-
BESP10 ✭✭✭✭✭✭
Hi row 10@Genevieve P.
-
Genevieve P. Employee Admin
Hey@BESP10
This is great, thank you!
我可以看到你的“项目经理”的价值column comes from a formula. Can you identify what that formula is?
- To test to see if the formula is blocking the workflow, can you try making the column formula acell formulaand then manually put in the correct contact, then test on that row
- It would also be helpful to know if the workflow triggers if you add a comment to the sheetdirectly(versus through Dynamic View)
- Another check we can do is to see if the workflow has been triggered, just stopped at some point due to the conditions or action:
Does this "Last Ran" timeline sync with the current tests you're doing?
Thanks!
Genevieve
Categories
@Shawn_K2<\/a> UGH I make a mistake. I copied your formula without looking at it close enough 😜<\/span><\/p> try =COUNTIFS({CPR Request Type}, HAS(@cell, \"VAVE\"))<\/p>"},{"commentID":382446,"body":" @Shawn_K2<\/a> <\/p> =COUNTIFS({CPR Request Type}, HAS(@cell, \"VAVE\"), {CPR Brand}, HAS(@cell, \"ING\"))<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106847,"type":"question","name":"Missing drop-down options in my filter selections. Where did they go?","excerpt":"I have been creating filters and for some reason a couple of my drop-down options are not showing up as filter selections, even though they are correctly showing up as drop-down options in the sheet. To illustrate, here are the drop-down options I have for a column in my sheet, which are working correctly: but when I try…","categoryID":321,"dateInserted":"2023-06-23T18:16:31+00:00","dateUpdated":null,"dateLastComment":"2023-06-26T16:54:06+00:00","insertUserID":162342,"insertUser":{"userID":162342,"name":"mgreenwalt","title":"coordinator","url":"https:\/\/community.smartsheet.com\/profile\/mgreenwalt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-26T17:20:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-27T06:21:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":65,"score":null,"hot":3375348637,"url":"https:\/\/community.smartsheet.com\/discussion\/106847\/missing-drop-down-options-in-my-filter-selections-where-did-they-go","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106847\/missing-drop-down-options-in-my-filter-selections-where-did-they-go","format":"Rich","lastPost":{"discussionID":106847,"commentID":382360,"name":"Re: Missing drop-down options in my filter selections. Where did they go?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382360#Comment_382360","dateInserted":"2023-06-26T16:54:06+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-27T06:21:56+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2JV6OYUHWHZT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-26T16:04:32+00:00","dateAnswered":"2023-06-26T15:48:56+00:00","acceptedAnswers":[{"commentID":382315,"body":" Thanks @topazfae<\/a> for your time and efforts and I'm happy to announce that @Genevieve P.<\/a> solved this challenge 😃<\/span> - <\/p> \"I can see that your two selections have 135 and 142 characters each. When I cut the character count under 100<\/strong>, they appear as options to filter by.\"<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":5410,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
<\/p>