Face Fit Test Register designed & delivered to NHS - NOW FOC to NHS Users - COVID_19 solutions

Debbie Sawyer
Debbie Sawyer ✭✭✭✭✭
edited 06/16/22 inSmartsheet Basics

聪明的业务流程es (SBP) has been working with NHS Tayside who urgently needed a solution to track and monitor the progress of their Resporatory Protection Programme to test and face fit all Frontline staff with Masks that protect them from common airborne diseases, urgent due to the COVID-19 situation. A template which was originally used by NHS Highlands throughout the Ebola crisis was re-designed to meet the current needs for Face Fit Testing, then adapted to monitor Skin Health of employees treating patients within NHS Tayside.

We are now also working with NHS Highlands to adapt the solution further to deliver a PPE stock management to give an indication of ongoing demand during this current crisis.

With the permission of these two important NHS clients, SBP are offering this template FREE OF CHARGE to any NHS Smartsheet Users; the template will come with up to 2 hrs of consultancy to guide users in how to complete the template and how to adjust it to their own data.

See our webpage for more information:https://www.smarterbusinessprocesses.com/11523-2/

    @chooley<\/a> If you are getting #REF I believe you will unfortunately have to redo everything. I don't quite understand how your intake sheet is set up but definitely lock that row too when you are done. <\/p>

    If by \"Project ID is a protected field\" you mean that column is an autonumber system column... you could change the column type to text, put in the project numbers you want for whatever row, and then change it back to an auto number. It will keep the number you entered and continue where it left off (you might have to tell it which number to start at when you switch it back). However this won't fix your #REF problem.<\/p>"},{"commentID":355717,"body":"

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

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

    If you turn off the Autonumbering and then add a new row at the top with the information manually or use the Request Snapshot feature to paste the information back on that new row, it should work (I think).<\/p>

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

    I hope that helps!<\/p>

    Have a fantastic week & Happy New Year!<\/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","log":{"dateUpdated":"2023-01-03 18:32:37","updateUser":{"userID":156412,"name":"chooley","url":"https:\/\/community.smartsheet.com\/profile\/chooley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!259vf8ZI4vI!unDmp3-Skvo!RO65iWGdrJu","dateLastActive":"2023-01-03T18:49:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":99208,"type":"question","name":"Creating Forms","excerpt":"I am trying to create a form where each time I receive information I input it on the form, then send the form to someone else to have more information input on the exact same form. Is this possible?","categoryID":321,"dateInserted":"2023-01-03T16:12:45+00:00","dateUpdated":null,"dateLastComment":"2023-01-03T16:29:48+00:00","insertUserID":156414,"insertUser":{"userID":156414,"name":"lakshe","url":"https:\/\/community.smartsheet.com\/profile\/lakshe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-03T16:46:25+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-01-03T22:27:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3345526353,"url":"https:\/\/community.smartsheet.com\/discussion\/99208\/creating-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99208\/creating-forms","format":"Rich","lastPost":{"discussionID":99208,"commentID":355711,"name":"Re: Creating Forms","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355711#Comment_355711","dateInserted":"2023-01-03T16:29:48+00:00","insertUserID":86866,"insertUser":{"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-01-03T22:27:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-03T16:49:30+00:00","dateAnswered":"2023-01-03T16:29:48+00:00","acceptedAnswers":[{"commentID":355711,"body":"

    @lakshe<\/a> Yes, this is possible, in a roundabout way. <\/p>

    To do this, you'll want to create a workflow automation that is triggered by adding a new row, which sends an update form to the next user. When creating the automation, you designate which data columns the next user should have on their update form. <\/p>

    Here's a link to some help on working with update requests:<\/p>

    https:\/\/help.smartsheet.com\/learning-track\/smartsheet-intermediate\/update-requests<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-03 16:49:30","updateUser":{"userID":156414,"name":"lakshe","url":"https:\/\/community.smartsheet.com\/profile\/lakshe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-03T16:46:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":99172,"type":"question","name":"Automation Workflows to add multiple Multi-Select field values","excerpt":"Is it possible to have multiple automation workflows that will simultaneously or sequentially process to add multiple values into a single cell? Here's my scenario. I've got data that gets entered into a sheet that has the potential to be missing elements. The hope is that my users will correct those gaps, but once…","categoryID":321,"dateInserted":"2022-12-30T20:05:37+00:00","dateUpdated":null,"dateLastComment":"2023-01-03T11:18:10+00:00","insertUserID":121055,"insertUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-01-03T21:51:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-03T18:04:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":29,"score":null,"hot":3345176627,"url":"https:\/\/community.smartsheet.com\/discussion\/99172\/automation-workflows-to-add-multiple-multi-select-field-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99172\/automation-workflows-to-add-multiple-multi-select-field-values","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":99172,"commentID":355673,"name":"Re: Automation Workflows to add multiple Multi-Select field values","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355673#Comment_355673","dateInserted":"2023-01-03T11:18:10+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-03T18:04:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BGBF7435OPL6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-03T14:04:24+00:00","dateAnswered":"2022-12-30T20:14:41+00:00","acceptedAnswers":[{"commentID":355610,"body":"

    Alright, I think I figured it out. I had three separate automation workflows looking at the same field. I put that into one workflow with multiple condition paths and it looks to be working as expected. The other issue was a bad trigger. Guess I just needed to write it out to you all. Thanks for the support.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-03 14:04:24","updateUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-01-03T21:51:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"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":334,"urlcode":"automations","name":"Automations"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">