Inspection Records

AndrewR
AndrewR
edited 12/09/19 inSmartsheet Basics

Hello

I want to produce a record for equipment inspections. There will be over 100 items of equipment to list and inspection frequencies vary. I will need to show evidence that the inspection has been carried out, by whom and on what date.

Ideally, it would be good to be able to show basic points checked (guards, cables, access, condition, controls, etc.) on each inspection record,

I also need to be able to look back at previous records to provide an audit trail.

Are there any templates I can use or any suggestions, please?

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 02/28/19

    Hi Andrew,

    Have you checked the Solution Center? There are great templates to start with.

    I'd recommend this one:Template: Inspection Tracking

    Hope that helps and let me know if I can help in any way!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    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.

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    Hi Andrew

    Smartsheet do provide lots of templates, but in my humble opinion, I find the best way to provide an IT solution for your scenario would be to design a sheet from scratch to match against your inspection process.

    Once your process is mapped out it is usually clear, from the detail of how the process flows, which fields you need in your sheet and which categories to use and what data to collect. To accommodate different type of equipment using different frequecies for inspections you could design multiple input forms which could be selected from a Dashboard or triggered from an alert looking at a previous inspection. The workflow for equipment inspection would generally use a Grid type sheet, Alerts & Actions, Webforms and Reports. All could be monitored through the Dashboard.

    再一次,我在opionion, templates are all very good, but fundamentally they are another persons thoughts on what data you need to capture and I believe for toolsets to work they need to be shaped to your processes and not the other way around (bending a process to fit around a template in IT).

    Happy to discuss this further, good luck with whichever solution (template or self design) you go with.

    Kind regards








    Debbie SawyerConsultant & Training Manager

    Smarter Processes mean happy people in successful businesses








  • Thanks Debbie

    That's helpful. I am a 'beginner' when it comes to Smartsheet but i can see it has the capacity to do what I want it to. I'm mostly used to grids and forms so the more complex functionality is a bit new to me (hence my reference to a template!).

    This must be a common requirement for anyone involved in machinery inspection recording, equipment monitoring or other OH&S requirements and a workable system would be a big benefit. I don't really feel like reinventing the wheel!

    How can you help me?

    问候

    Andrew

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    Hi Andrew

    I could help in a number of ways, the main 2 would be to:

    • Analyse your inspection report requirements (in a little more detail that posted here) and set up your solution for you and transfer ownership of it back to you once you are happy that it works. This would/could involve starting at mapping out your process, seeing where it fits with Smartsheet, creating all the sheets necessary, training you in how to maintain the solution.
    • Train you in all the necessary skills to be able to set this up for yourself. I run either face to face training in the UK but if you are based further afield, I run remote training sessions (90 mins at a time) using Zoom Meeting conferencing tool (which is excellent!). This allows us to connect, hear each other, allows screen shares and with Smartsheet and us both sharing a workspace I can see what you are doing and aid you in your development.

    If one of the above looks good to you, or if you have a different idea of how you would prefer to engage my email is[email protected].

    Kind regards

    Debbie SawyerConsultant & Training Manager

    Smarter Processes mean happy people in successful businesses

  • Hello there, I’d appreciate if you advise the availability of training sessions on how to create an inspection form. I need it for daily site/equipment inspections required by OSHA. Thank you!

  • Melissa Boehl
    Melissa Boehl ✭✭✭✭✭✭
    edited 08/12/22

    @AndrewR@Giulia AliI have created an equipment inspection and checkout/in workspace for our environmental group. I would be happy to copy and clear the data then share with you. I am also happy to help you adjust it to meet your business needs. Please let me know if your interested and I can start working on it this weekend!!

    Btw: I am the Smartsheet Administrator for my engineering firm of approx. 400 employees. I am also a consultant part time on the weekends. I provide Smartsheet design/build services for personal, business, municipalities and non profit groups.

    Melissa Boehl

    Business Systems Analyst ~ WithersRavenel

    115 MacKenan Drive|Cary, NC 27511

    Office: 919.469.3340|Direct: 919.238.0436

    [email protected]

    Did I answer to your question or fix the problem? PleasehelptheSmartsheet CommunitybyclickingAnswer Accepted. It will make it easier for users to discover solutions and resolve problems.

  • Melissa Boehl
    Melissa Boehl ✭✭✭✭✭✭

    @Giulia Ali@AndrewR

    Also, unlike other consultants on here, I never charge fees to help build out processes. Many times businesses will send me an unsolicited payment because they are grateful. But it is absolutely not required. I enjoy helping others improve their systems and processes. So please do not hesitate to reach out. I'm happy to help!!

    Melissa Boehl

    Business Systems Analyst ~ WithersRavenel

    115 MacKenan Drive|Cary, NC 27511

    Office: 919.469.3340|Direct: 919.238.0436

    [email protected]

    Did I answer to your question or fix the problem? PleasehelptheSmartsheet CommunitybyclickingAnswer Accepted. It will make it easier for users to discover solutions and resolve problems.

  • Melissa Boehl
    Melissa Boehl ✭✭✭✭✭✭

    @Giulia Ali我可以使用当前Osha向通用报告的副本nerate something for you. I have also worked with OSHA so I have an idea of what you may need.

    Melissa Boehl

    Business Systems Analyst ~ WithersRavenel

    115 MacKenan Drive|Cary, NC 27511

    Office: 919.469.3340|Direct: 919.238.0436

    [email protected]

    Did I answer to your question or fix the problem? PleasehelptheSmartsheet CommunitybyclickingAnswer Accepted. It will make it easier for users to discover solutions and resolve problems.

Fixed, needed to add \"Value\" before the formula to remove the apostrophe.<\/p>


<\/p>

=VALUE(IFERROR(JOIN(DISTINCT(COLLECT([Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, [Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, <>\"\"))), \" \"))<\/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":109460,"type":"question","name":"IF \/ OR formula then Check a Box","excerpt":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1) OR([Study Status]@row = \"In Start-Up\", 1))","snippet":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1)…","categoryID":321,"dateInserted":"2023-08-25T13:30:39+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T16:21:27+00:00","insertUserID":9250,"insertUser":{"userID":9250,"name":"Susan Swisher","url":"https:\/\/community.smartsheet.com\/profile\/Susan%20Swisher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T16:23:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T02:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":47,"score":null,"hot":3385956126,"url":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109460,"commentID":392616,"name":"Re: IF \/ OR formula then Check a Box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392616#Comment_392616","dateInserted":"2023-08-25T16:21:27+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T02:16:35+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-25T15:13:03+00:00","dateAnswered":"2023-08-25T14:14:39+00:00","acceptedAnswers":[{"commentID":392575,"body":"

Give this a try:<\/p>

=IF(OR([Study Status]@row = \"Active\/Open to Accrual\", [Study Status]@row = \"In Start-Up\"), 1)<\/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":109457,"type":"question","name":"Conditional Formatting (modified date not in the last 3 weeks)","excerpt":"I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated (last 3 weeks) should be highlighted in yellow. Is this spmething that can be done directly within conditional formatting or should I first create a…","snippet":"I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated…","categoryID":321,"dateInserted":"2023-08-25T12:33:14+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161267,"lastUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3385935251,"url":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":109457,"commentID":392553,"name":"Re: Conditional Formatting (modified date not in the last 3 weeks)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392553#Comment_392553","dateInserted":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+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-25T12:40:09+00:00","dateAnswered":"2023-08-25T12:37:47+00:00","acceptedAnswers":[{"commentID":392551,"body":"

There is no direct way to do this. Adding a checkbox helper column with something similar to this and then formatting based on the checkbox is the simplest way. You can even hide the extra column, as there is no reason for it to be visible.<\/p>

=IF([Modified Date]@row < TODAY(-21), 1, 0)<\/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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"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":4991,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics