Workflow - when box is checked

Hi there,

I feel like this is an easy one, but for some reason I'm a bit confused about how to get it done - I want to trigger an alert when a box is checked - either when the row is added or when it is checked at a later point.


I was going to do 'when rows are added or changed' and 'xx' box is checked, but, I don't want the users to get alerts when there are changes to the row; I just want them to get a notification whenever the box is checked. Help!

Best Answer

Answers

Hi @htperth<\/a> <\/p>

I hope you're well and safe!<\/p>

Have you checked the Sheets and the Deleted sections?<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week & Happy Independence Day!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":107192,"type":"question","name":"Unwanted calendar view","excerpt":"There is a small calendar view appearing to the right of my report when I add the report to the dashboard. Where is this originating from and how do I delete it? It is not meaningful, and it is obscuring part of the report and making it necessary to scroll to see some of the report data. ","snippet":"There is a small calendar view appearing to the right of my report when I add the report to the dashboard. Where is this originating from and how do I delete it? It is not…","categoryID":321,"dateInserted":"2023-07-03T20:53:00+00:00","dateUpdated":"2023-07-04T08:17:45+00:00","dateLastComment":"2023-07-04T09:28:42+00:00","insertUserID":142896,"insertUser":{"userID":142896,"name":"kathyb","url":"https:\/\/community.smartsheet.com\/profile\/kathyb","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-04T12:11:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-05T14:34:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":29,"score":null,"hot":3376881102,"url":"https:\/\/community.smartsheet.com\/discussion\/107192\/unwanted-calendar-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107192\/unwanted-calendar-view","format":"Rich","lastPost":{"discussionID":107192,"commentID":383626,"name":"Re: Unwanted calendar view","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383626#Comment_383626","dateInserted":"2023-07-04T09:28:42+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-05T14:34:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-04T12:12:03+00:00","dateAnswered":"2023-07-04T09:28:42+00:00","acceptedAnswers":[{"commentID":383626,"body":"

Hi @kathyb<\/a> <\/p>

It sounds like you may have your Report set to Gantt view instead of purely Grid view. You can change this from the side panel in the Report Widget by selecting Hide Gantt<\/strong>:<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

Cheers,<\/p>

Genevieve<\/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":107184,"type":"question","name":"JOIN COLLECT with multiple criteria including star - need help!","excerpt":"Trying to do a JOIN COLLECT to collect multiple data points from one column (candidate full name) when there is a match to the current row (faculty@row) and the row is starred (cohort@row). Formula below, getting #INCORRECT ARGUMENT SET error. When I test only the Faculty@row range\/criteria, the formula works. When I test…","snippet":"Trying to do a JOIN COLLECT to collect multiple data points from one column (candidate full name) when there is a match to the current row (faculty@row) and the row is starred…","categoryID":321,"dateInserted":"2023-07-03T17:50:29+00:00","dateUpdated":null,"dateLastComment":"2023-07-03T20:06:36+00:00","insertUserID":128195,"insertUser":{"userID":128195,"name":"Robin Sugiura","url":"https:\/\/community.smartsheet.com\/profile\/Robin%20Sugiura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-03T18:05:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-05T13:05:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3376823225,"url":"https:\/\/community.smartsheet.com\/discussion\/107184\/join-collect-with-multiple-criteria-including-star-need-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107184\/join-collect-with-multiple-criteria-including-star-need-help","format":"Rich","lastPost":{"discussionID":107184,"commentID":383582,"name":"Re: JOIN COLLECT with multiple criteria including star - need help!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383582#Comment_383582","dateInserted":"2023-07-03T20:06:36+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-05T13:05:19+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-04T08:31:35+00:00","dateAnswered":"2023-07-03T17:58:30+00:00","acceptedAnswers":[{"commentID":383559,"body":"

The Cohort range needs to be a full column range the same as the other two ranges.<\/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=321&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":4826,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics