Automations

Discussion List

I do not want my name on these automation emails, is there a way to change it to someone (workspace collaborators \/ users) via…","categoryID":321,"dateInserted":"2022-05-23T13:15:58+00:00","dateUpdated":null,"dateLastComment":"2022-06-22T14:22:23+00:00","insertUserID":148125,"insertUser":{"userID":148125,"name":"Fabian Julian","url":"https:\/\/community.smartsheet.com\/profile\/Fabian%20Julian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-22T14:23:29+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-08-22T19:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":1906,"score":1,"hot":3309225801,"url":"https:\/\/community.smartsheet.com\/discussion\/91381\/change-the-from-email-address-on-automated-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91381\/change-the-from-email-address-on-automated-emails","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-22T14:14:50+00:00","dateAnswered":"2022-06-21T14:48:17+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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}]},{"discussionID":92414,"type":"question","name":"Health Status Formula RYGG","excerpt":"Hello, I am new to smartsheets and I am having difficulties setting up basic Health Formula with RYG+Gray bullets based on Status (Cancelled, Delivered) and Due date column. GRAY when Status is Cancelled RED when Status is Delivered, but after Due date GREEN when Status is Delivered till and on Due date YELLOW when none of…","categoryID":322,"dateInserted":"2022-06-21T10:39:18+00:00","dateUpdated":"2022-06-21T10:58:17+00:00","dateLastComment":"2022-06-22T12:53:22+00:00","insertUserID":149022,"insertUser":{"userID":149022,"name":"Natasa5","url":"https:\/\/community.smartsheet.com\/profile\/Natasa5","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!78tQuxDWP7s!3AFS__DsBvs!jQnd3tDGChL","dateLastActive":"2022-12-09T14:23:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":149022,"lastUser":{"userID":149022,"name":"Natasa5","url":"https:\/\/community.smartsheet.com\/profile\/Natasa5","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!78tQuxDWP7s!3AFS__DsBvs!jQnd3tDGChL","dateLastActive":"2022-12-09T14:23:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":113,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/92414\/health-status-formula-rygg","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92414\/health-status-formula-rygg","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-25T08:49:41+00:00","dateAnswered":"2022-06-22T11:37:13+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":92446,"type":"question","name":"3 Month Compliance Tracking","excerpt":"Hello SS Community! I've read lots of answers over time but never asked my own question so here goes nothing! I need to create a tracker for individual employee Compliance for training. We have many tests that each employee performs, but they must stay compliant within 3 months. They can't go 3 months without doing one…","categoryID":321,"dateInserted":"2022-06-21T19:00:37+00:00","dateUpdated":"2022-06-22T09:54:51+00:00","dateLastComment":"2022-06-21T21:17:57+00:00","insertUserID":149288,"insertUser":{"userID":149288,"name":"Jake E","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20E","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-19T12:51:51+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-22T19:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":112,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/92446\/3-month-compliance-tracking","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92446\/3-month-compliance-tracking","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-21T19:25:36+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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}]},{"discussionID":92438,"type":"idea","name":"Folders for Automations","excerpt":"I have many sheets that have a TON of Automations that I have built. I would like to see folders for automations be added where you can group your automations that work together into folders for easy navigation when editing. Currently, I have to scroll an endless list of automations to find the one that I am attempting to…","categoryID":349,"dateInserted":"2022-06-21T15:38:08+00:00","dateUpdated":"2022-06-22T09:59:12+00:00","dateLastComment":"2022-06-21T15:38:08+00:00","insertUserID":134082,"insertUser":{"userID":134082,"name":"PBullis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/PBullis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-18T21:40:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":134082,"lastUser":{"userID":134082,"name":"PBullis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/PBullis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-18T21:40:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":223,"score":1,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92438\/folders-for-automations","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92438\/folders-for-automations","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":92231,"type":"question","name":"Updates Occur After Date Specified is Reached","excerpt":"I need for updates to Profile sheet to pull data from Exception sheet only when the date is reached based on the employee #. Scenario: An employee wants to increase their 401K contribution by $100 every quarter. Profile has Benefit Effective Date: 4\/1\/22, 401K Contribution: $100. Exception sheet has 3 exceptions submitted:…","categoryID":322,"dateInserted":"2022-06-15T22:01:07+00:00","dateUpdated":"2022-06-16T11:07:24+00:00","dateLastComment":"2022-06-21T12:58:05+00:00","insertUserID":148100,"insertUser":{"userID":148100,"name":"SMullen","url":"https:\/\/community.smartsheet.com\/profile\/SMullen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!e4FTZ6S5Ivo!28lTP6TgZTo!DccP-KzUpae","dateLastActive":"2022-07-29T16:04:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":148100,"lastUser":{"userID":148100,"name":"SMullen","url":"https:\/\/community.smartsheet.com\/profile\/SMullen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!e4FTZ6S5Ivo!28lTP6TgZTo!DccP-KzUpae","dateLastActive":"2022-07-29T16:04:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":124,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/92231\/updates-occur-after-date-specified-is-reached","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92231\/updates-occur-after-date-specified-is-reached","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-21T12:47:06+00:00","dateAnswered":"2022-06-21T12:33:33+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]},{"discussionID":92402,"type":"idea","name":"Mass Email Communication with customized attachments.","excerpt":"Greetings. I have been working on a project to manage communication with large group based on activities we produce. At the end of each activity we create custom certificates for each participant. I have been working to automate this process as much as possible, however I would LOVE to see some system based formatting…","categoryID":349,"dateInserted":"2022-06-20T22:24:19+00:00","dateUpdated":"2022-06-21T13:39:53+00:00","dateLastComment":"2022-06-20T22:24:19+00:00","insertUserID":148351,"insertUser":{"userID":148351,"name":"Leslie Kuhlman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leslie%20Kuhlman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/BA6MCG1WI0T6\/n5AJDZO1ML0L1.png","dateLastActive":"2023-08-07T12:44:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":148351,"lastUser":{"userID":148351,"name":"Leslie Kuhlman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leslie%20Kuhlman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/BA6MCG1WI0T6\/n5AJDZO1ML0L1.png","dateLastActive":"2023-08-07T12:44:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":250,"score":9,"hot":3311585352,"url":"https:\/\/community.smartsheet.com\/discussion\/92402\/mass-email-communication-with-customized-attachments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92402\/mass-email-communication-with-customized-attachments","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/QTF26K2FYMB0\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":92392,"type":"idea","name":"Better automation design: visual queues","excerpt":"I have a love\/hate relationship with Smartsheet automation. On one hand, the automation has saved me countless hours of work. On the other hand, the way the Automation for a sheet pops out and covers up the data is maddening! Having the automation pop up in a separate, re-sizeable window would be awesome. Taking it a step…","categoryID":349,"dateInserted":"2022-06-20T17:40:11+00:00","dateUpdated":"2022-06-21T08:17:51+00:00","dateLastComment":"2022-06-20T17:40:11+00:00","insertUserID":129416,"insertUser":{"userID":129416,"name":"Ian Cooper","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ian%20Cooper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!YflcmKRQTro!xJNe8QRp7fo!rvnoXK5G_kj","dateLastActive":"2023-05-24T19:04:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":129416,"lastUser":{"userID":129416,"name":"Ian Cooper","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ian%20Cooper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!YflcmKRQTro!xJNe8QRp7fo!rvnoXK5G_kj","dateLastActive":"2023-05-24T19:04:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":245,"score":1,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92392\/better-automation-design-visual-queues","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92392\/better-automation-design-visual-queues","format":"Rich","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/M5QYS1G14FY7\/decision-tree-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Decision tree.JPG"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":92372,"type":"discussion","name":"Automation - \"Move Row at a certain time\" sending lines multiple times","excerpt":"Edit - I have worked it out! Simple fix and definite UE! I had 2 automations with the same time. 🤦 I have an automation set up to move all rows from a mini-sheet into a mastersheet\/archive every evening at 9pm. This is the only \"move row\" automation I now have as I have taken off everything else. This morning I opened my…","categoryID":321,"dateInserted":"2022-06-20T08:32:44+00:00","dateUpdated":"2022-06-20T08:36:10+00:00","dateLastComment":"2022-06-20T09:08:43+00:00","insertUserID":142331,"insertUser":{"userID":142331,"name":"LydiaBR","url":"https:\/\/community.smartsheet.com\/profile\/LydiaBR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QRTWEJPEOH93\/n9T6CYUSIC97J.jpg","dateLastActive":"2023-01-26T10:45:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":142331,"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-08-22T17:41:59+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":74,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92372\/automation-move-row-at-a-certain-time-sending-lines-multiple-times","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92372\/automation-move-row-at-a-certain-time-sending-lines-multiple-times","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":92235,"type":"question","name":"JOIN COLLECT FORMULA","excerpt":"IN PICTURE (A)- i have successful JOIN COLLECT formula IN PICTURE (B)- I tried to replicate the formula, but add additional columns I needed to be joined as well. IN PICTURE (B-1) Incorrrect Argument","categoryID":322,"dateInserted":"2022-06-15T22:27:22+00:00","dateUpdated":"2022-06-16T11:06:18+00:00","dateLastComment":"2022-06-18T03:49:36+00:00","insertUserID":143257,"insertUser":{"userID":143257,"name":"Bobby1","url":"https:\/\/community.smartsheet.com\/profile\/Bobby1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-26T14:21:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-08-23T02:06:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":694,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92235\/join-collect-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92235\/join-collect-formula","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ETPVTL433N6L\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-21T15:22:59+00:00","dateAnswered":"2022-06-18T03:49:36+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">