How to include changed fields in an alert
I want to alert the project manager of any changes to records managed by that project manager and include only the values of the fields that changed. The fields that were modified could be 1 or more of dozens. So I do not want to include ALL fields -- only those which have been modified.
Is that possible?
Best Answer
-
Paul Newcome ✭✭✭✭✭✭@Michael JORDAN我越是深入,更多的合并cated it gets. And I mean extremely complicated. It is THEORETICALLY possible, but it is quite a bit of a headache to get set up.
My suggestion would be to include the link to the sheet and turn on the Highlight Changes feature.
Answers
-
Paul Newcome ✭✭✭✭✭✭
It is possible with a separate sheet and some cross sheet references along with a couple of hidden helper columns but depends on the size of your sheet. How many columns do you want to evaluate, and how many rows are there?
-
Thanks, Paul. There are 20 columns I'd want to evaluate. And there are about 200 active rows.
-
Paul Newcome ✭✭✭✭✭✭
When you say "Active", do you have any "inactive" rows that contain data? The solution requires referencing all rows and all columns, so I want to make sure we are not going to reach any of the limits.
-
The overall smartsheet has 110 columns and 1,262 rows, the vast majority of which include data.
-
Paul Newcome ✭✭✭✭✭✭
Ok. Even with only the 20 columns, 1,262 rows exceeds the cells referenced in a cross sheet reference. I am going to have to do some testing on some ideas for a workaround. I will let you know what I find when I am able.
-
Paul that would be amazing! Thank you.
-
Paul Newcome ✭✭✭✭✭✭
@Michael JORDAN我越是深入,更多的合并cated it gets. And I mean extremely complicated. It is THEORETICALLY possible, but it is quite a bit of a headache to get set up.
My suggestion would be to include the link to the sheet and turn on the Highlight Changes feature.
-
Thank you for looking into it!
-
Paul Newcome ✭✭✭✭✭✭
I am always happy to take a look. Sorry I couldn't be of more help.
Categories
They can be added if they use a different domain.<\/p>
<\/p>
If they are licensed on another account, they would need to either be first removed from that account (can cause some logistical headaches) or added as an unlicensed user on your account.<\/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":543,"urlcode":"licensed-users","name":"licensed users"}]},{"discussionID":108737,"type":"question","name":"Visibility on Form Submission","excerpt":"Is there a way to increase visibility for requestors on their submitted requests? Like is it possible to send the requestors all of the requests they've submitted so they can see what they've requested, date, description, etc.","snippet":"Is there a way to increase visibility for requestors on their submitted requests? Like is it possible to send the requestors all of the requests they've submitted so they can see…","categoryID":321,"dateInserted":"2023-08-09T15:23:45+00:00","dateUpdated":"2023-08-09T15:24:46+00:00","dateLastComment":"2023-08-09T18:04:13+00:00","insertUserID":164850,"insertUser":{"userID":164850,"name":"ocanel","title":"Analyst","url":"https:\/\/community.smartsheet.com\/profile\/ocanel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-09T17:57:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-08-12T01:26:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":51,"score":null,"hot":3383201878,"url":"https:\/\/community.smartsheet.com\/discussion\/108737\/visibility-on-form-submission","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108737\/visibility-on-form-submission","format":"Rich","tagIDs":[204,324,334,440,448],"lastPost":{"discussionID":108737,"commentID":389865,"name":"Re: Visibility on Form Submission","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389865#Comment_389865","dateInserted":"2023-08-09T18:04:13+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-08-12T01:26:49+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-08-09T17:57:54+00:00","dateAnswered":"2023-08-09T15:59:17+00:00","acceptedAnswers":[{"commentID":389837,"body":"
