Automations

TODAY(), Finish@row > TODAY()), \"Not Started\", IF(AND(Start@row < TODAY(), Finish@row > TODAY()), \"In…","categoryID":322,"dateInserted":"2022-01-25T23:07:32+00:00","dateUpdated":null,"dateLastComment":"2022-01-26T17:26:03+00:00","insertUserID":144108,"insertUser":{"userID":144108,"name":"Sierra G","url":"https:\/\/community.smartsheet.com\/profile\/Sierra%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-01-25T23:00:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144108,"lastUser":{"userID":144108,"name":"Sierra G","url":"https:\/\/community.smartsheet.com\/profile\/Sierra%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-01-25T23:00:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":384,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/87289\/nesting-isblank-within-if-and-statements","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/87289\/nesting-isblank-within-if-and-statements","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-01-26T17:28:11+00:00","dateAnswered":"2022-01-26T01:59:50+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":440,"urlcode":"project-management","name":"Project Management"},{"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":87286,"type":"question","name":"Log of Alerts","excerpt":"How do I find a log of the alerts that have been sent? I am trying to determine if an automation that I set up is working.","categoryID":321,"dateInserted":"2022-01-25T22:16:57+00:00","dateUpdated":null,"dateLastComment":"2022-01-26T15:27:53+00:00","insertUserID":140772,"insertUser":{"userID":140772,"name":"Shauna_LCCC_WY","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shauna_LCCC_WY","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/UE9FDLPQA78A\/nCQ26LK1CZJ92.jpg","dateLastActive":"2022-01-25T22:15:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144140,"lastUser":{"userID":144140,"name":"Shauna Leigh","url":"https:\/\/community.smartsheet.com\/profile\/Shauna%20Leigh","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgOJfFGfYsjCl4OIpcagxf6UhfbfqYRINEQ9qY2=s96-c","dateLastActive":"2022-01-26T15:27:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":124,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/87286\/log-of-alerts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/87286\/log-of-alerts","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-26T14:42:48+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"}],"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":87252,"type":"question","name":"Simply Retrieving Last Row Referenced in Another Sheet","excerpt":"Simply, I need to reference another sheet and get all column values on the LAST row!!! I thought this should be simple to do by indexing another sheet, then capturing the last row and include all column values in this last row??? See Example: =INDEX({EXTERNAL SMARTSHEET Range 20}, LAST ROW, ALL COLUMNS) What am I doing…","categoryID":322,"dateInserted":"2022-01-25T13:59:37+00:00","dateUpdated":null,"dateLastComment":"2022-01-25T18:54:02+00:00","insertUserID":144070,"insertUser":{"userID":144070,"name":"kmforecasting","url":"https:\/\/community.smartsheet.com\/profile\/kmforecasting","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GjeenFXb9SDatFurMRzhvK9fwwTl1SFWrSXATuM=s96-c","dateLastActive":"2022-04-07T13:19:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":86866,"lastUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-07-11T19:04:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":546,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/87252\/simply-retrieving-last-row-referenced-in-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/87252\/simply-retrieving-last-row-referenced-in-another-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-25T18:54:02+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":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":87261,"type":"question","name":"Report Builder Automations","excerpt":"Hello Smartsheet Community, I'm building a report and I'm wondering if I click into an entire folder collection for my source sheet, will the report auto-include new grids that get added to those folders or will I have to manually add them as they get created?","categoryID":321,"dateInserted":"2022-01-25T15:51:44+00:00","dateUpdated":null,"dateLastComment":"2022-01-25T17:04:52+00:00","insertUserID":135919,"insertUser":{"userID":135919,"name":"Drea Mora","url":"https:\/\/community.smartsheet.com\/profile\/Drea%20Mora","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ut1Dp0UyliQ!5NDCOclHZ5Y!r2ab8mv_6rL","dateLastActive":"2023-03-30T20:32:49+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-07-13T09:23:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":83,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/87261\/report-builder-automations","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/87261\/report-builder-automations","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BWQ9IMU0M4FC\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-25T16:49:18+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":265,"urlcode":"Reports","name":"Reports"},{"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":84847,"type":"question","name":"Email automations in report not working","excerpt":"Hi. I need help with setting up a report to send monthly to specific email addresses every month. I saw others recommendations on automating the \"Send as Attachment\" in the report, which I tried and it is not sending the reports. Here's the steps I tried: I created a report \"Gas Receipts Monthly Report\" which will send a…","categoryID":322,"dateInserted":"2021-11-10T16:54:26+00:00","dateUpdated":null,"dateLastComment":"2022-01-25T16:44:44+00:00","insertUserID":134622,"insertUser":{"userID":134622,"name":"Office of the Medical Director","url":"https:\/\/community.smartsheet.com\/profile\/Office%20of%20the%20Medical%20Director","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T22:12:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":28096,"lastUser":{"userID":28096,"name":"Dale Murphy","url":"https:\/\/community.smartsheet.com\/profile\/Dale%20Murphy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/09\/85\/n09854db3c85d2fcac04eb0a42036548e.jpg","dateLastActive":"2023-05-17T20:43:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":83,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/84847\/email-automations-in-report-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84847\/email-automations-in-report-not-working","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EN7SHDSM2KD5\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-01-25T16:37:14+00:00","dateAnswered":"2021-11-10T22:40:58+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":265,"urlcode":"Reports","name":"Reports"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"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":86811,"type":"question","name":"Grouped Update Requests","excerpt":"I am looking for a way to send multiple update requests in a single email. Here is the scenario. Once a product is inspected, I want to check a Smartsheet checkbox saying that it passed inspection. Then I want Smartsheet to automatically send out an update request to our shipping department telling them to go ahead and…","categoryID":321,"dateInserted":"2022-01-22T00:51:14+00:00","dateUpdated":null,"dateLastComment":"2022-01-25T16:16:25+00:00","insertUserID":106151,"insertUser":{"userID":106151,"name":"M38a1","url":"https:\/\/community.smartsheet.com\/profile\/M38a1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n7ZG0TBD44T33.png","dateLastActive":"2022-09-19T22:58:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":106151,"lastUser":{"userID":106151,"name":"M38a1","url":"https:\/\/community.smartsheet.com\/profile\/M38a1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n7ZG0TBD44T33.png","dateLastActive":"2022-09-19T22:58:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":353,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/86811\/grouped-update-requests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86811\/grouped-update-requests","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-01-25T16:16:30+00:00","dateAnswered":"2022-01-22T04:00:01+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":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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":86129,"type":"question","name":"Automation in one sheet to change cell in another sheet?","excerpt":"I have two sheets in our workspace, one is the master list of projects we are working on, the other is used to record the amount of time each person works on a project for a given date. Projects sheet Timesheet sheet Project ID Project ID Project Name Staff Name Status Date Priority Hours Worked etc. etc. A project gets a…","categoryID":321,"dateInserted":"2022-01-03T22:16:44+00:00","dateUpdated":"2022-01-03T22:23:30+00:00","dateLastComment":"2022-01-24T15:49:07+00:00","insertUserID":142506,"insertUser":{"userID":142506,"name":"Matt Rasmussen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Rasmussen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pmNoqQPjsnM!Drcpw0_e3Ls!m7LDO04I6XR","dateLastActive":"2023-07-12T16:12:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":142506,"lastUserID":142506,"lastUser":{"userID":142506,"name":"Matt Rasmussen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Rasmussen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pmNoqQPjsnM!Drcpw0_e3Ls!m7LDO04I6XR","dateLastActive":"2023-07-12T16:12:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":1591,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/86129\/automation-in-one-sheet-to-change-cell-in-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86129\/automation-in-one-sheet-to-change-cell-in-another-sheet","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-01-24T15:31:01+00:00","dateAnswered":"2022-01-04T21:28:43+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":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":86804,"type":"question","name":"New here, general questions","excerpt":"Hi, Do you have to write all the functions yourself or are there tools to help with the process. I need to do a xlookup index and matching update to another sheet. I'm use to work with ablebits tools. While I'm here, it is possible to upload to a file to overwrite (update) data on a current sheet? Can I sync two sheets so…","categoryID":321,"dateInserted":"2022-01-21T21:42:48+00:00","dateUpdated":null,"dateLastComment":"2022-01-24T13:59:22+00:00","insertUserID":143751,"insertUser":{"userID":143751,"name":"Kimbersh","url":"https:\/\/community.smartsheet.com\/profile\/Kimbersh","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJy8w9PwjNUiQqLU8GDqqm3z_8YB1pUSRcnVARqA=s96-c","dateLastActive":"2022-02-17T15:13:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-13T08:02:48+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":286,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/86804\/new-here-general-questions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86804\/new-here-general-questions","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-24T13:59:22+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":241,"urlcode":"Calendar","name":"Calendar View"},{"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":86533,"type":"question","name":"Employee Fit Testing Tracking","excerpt":"I am very new to creating my own smart sheets, I am looking to create a tracking of Employee Respirator Fit Testing. This sheet would need a away to annually updated by testing completion date as well as the type of mask they tested on, noting that some employees with have to complete fit testing on multiple masks each of…","categoryID":322,"dateInserted":"2022-01-13T22:54:19+00:00","dateUpdated":null,"dateLastComment":"2022-01-21T22:00:33+00:00","insertUserID":142722,"insertUser":{"userID":142722,"name":"Geard Ledet ","url":"https:\/\/community.smartsheet.com\/profile\/Geard%20Ledet%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-16T19:25:39+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-07-13T09:23:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":154,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/86533\/employee-fit-testing-tracking","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86533\/employee-fit-testing-tracking","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-13T23:53:06+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">