Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Smartsheets for medical practices

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Be careful with HIPAA.

    I don't believe many SaaS cloud based systems satisfy the most recent requirements.

    But I'm not paranoid, I'm just convinced they are out to get me (and my data)

    Craig

    · Share on Facebook Share on Twitter
  • Tony Davidson - SmartSheet Certified User 2016
    Tony Davidson - SmartSheet Certified User 2016 ✭✭✭✭✭✭
    edited 09/26/16

    These very large hospitals at this link below publically endorse SmartSheet..

    //m.santa-greenland.com/customers

    · Share on Facebook Share on Twitter
  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    George,

    If you mean using SS to manage a Project Plan for a project in the medical industry, I think you are fine. But as for handling medical data see the info from the link below.

    Tim

    //m.santa-greenland.com/security-info

    HIPAA Statement

    UnderHIPAA, certain information about a person’s health or health care services is classified as Protected Health Information (PHI). Smartsheet customers who are subject to HIPAA are advised to refrain from storing PHI in Smartsheet. Smartsheet does not enter into Business Associate Agreements (BAA

    · Share on Facebook Share on Twitter
  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Hi George, I guess with a name like yours, you must be in the USA? (empty profile?)

    However this may help...In the UK we have numerous NHS orgs using Smartsheet to plan their projects and deliver them very successfully and growing fast. Also and even bigger usage is for the Administrators, Health and Safety, Property & Estate managers... the list goes on; with one golden rule. No patient data is included in Smartsheet, but that is fine because there is a very robust system for that data anyway.

    What Smartsheet is good at (as we all know) is getting the work done and generating efficiencies of 30% or better, compared to legacy systems. But these public servants are rightly careful with our confidential data.

    So my answer to you George is yes, Smartsheet is ideal! and make sure you tell all your colleagues in the other departments, they will thank you!

    Regards

    RichardR

    · Share on Facebook Share on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee

    Hello all,

    We've recently made a change to our policy on HIPAA compliance.

    By entering in a business associate agreement (BAA) with Smartsheet and adhering to the Smartsheet HIPAA Implementation Guide, your organization can use Smartsheet in accordance with HIPAA.

    To start the process of becoming HIPAA compliant with Smartsheet, please visitSmartsheet for Healthcare.

    · Share on Facebook Share on Twitter
  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    thanks for the info! I'll pass along internally.

    Tim

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

Hi Dear Andrée Starå<\/strong><\/a><\/p>

Thank you so much for your solution!<\/p>

It can work, but more like a compromise way. Editing on a report is less convenient.<\/p>

It would be better for me to set access right to each column.<\/p>

But that can also work for now, thanks a lot.<\/p>

By the way are you a BOT?<\/p>"},{"commentID":383283,"body":"

@流风回雪<\/a> <\/p>

Excellent!<\/p>

Happy to help!<\/p>

I agree. Great idea! That would be a great addition to Smartsheet features.<\/p>

Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p>

Haha!, No, I'm not a bot! 🤣<\/span><\/p>

✅Remember! <\/strong>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"},"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":107112,"type":"question","name":"How to we exclude a specific name from a DISTINCT LIST USER formula","excerpt":"I would like to exclude a specific user name from this formula. The formula is working fine, and it is returning a distinct list of user names. However, we need to exclude certain users, that are no longer in the group. For example, how do I say to exclude user \"Joe Black\" from this list? =IFERROR(INDEX(DISTINCT({Trial…","snippet":"I would like to exclude a specific user name from this formula. The formula is working fine, and it is returning a distinct list of user names. However, we need to exclude certain…","categoryID":322,"dateInserted":"2023-06-29T22:30:22+00:00","dateUpdated":"2023-06-29T22:33:31+00:00","dateLastComment":"2023-06-30T13:51:12+00:00","insertUserID":157974,"insertUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T14:54:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":157974,"lastUserID":157974,"lastUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T14:54:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":64,"score":null,"hot":3376213894,"url":"https:\/\/community.smartsheet.com\/discussion\/107112\/how-to-we-exclude-a-specific-name-from-a-distinct-list-user-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107112\/how-to-we-exclude-a-specific-name-from-a-distinct-list-user-formula","format":"Rich","lastPost":{"discussionID":107112,"commentID":383323,"name":"Re: How to we exclude a specific name from a DISTINCT LIST USER formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383323#Comment_383323","dateInserted":"2023-06-30T13:51:12+00:00","insertUserID":157974,"insertUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T14:54:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T13:43:49+00:00","dateAnswered":"2023-06-30T12:01:20+00:00","acceptedAnswers":[{"commentID":383296,"body":"

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

You can use a COLLECT Function<\/a> to filter results, for example:<\/p>

=IFERROR(INDEX(DISTINCT(COLLECT(<\/strong>{Trial Lead}, {Trial Lead}, <> \"Joe Black\")<\/strong>), [Unique Row ID]@row, 0), \"//m.santa-greenland.com/community/discussion/comment/\")<\/p>

An alternative would be to use a Report and Group by the Trial Lead column, ignoring out the users you don't want by adding them to the filter criteria in the Report.<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":107109,"type":"question","name":"Bridge Workflow - Runs with no Errors but doesn't copy data to column. Am I missing modules?","excerpt":"I have a Bridge Workflow that is set up to copy data from a row\/column to the same row\/different column. The workflow runs with all module steps \"SUCCEDED\". However, the end result is not copied in my Smartsheet's target column. Its blank. Am I missing a module or module steps to complete the copy routine? -- Here's a…","snippet":"I have a Bridge Workflow that is set up to copy data from a row\/column to the same row\/different column. The workflow runs with all module steps \"SUCCEDED\". However, the end…","categoryID":343,"dateInserted":"2023-06-29T21:27:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T15:01:40+00:00","insertUserID":148855,"insertUser":{"userID":148855,"name":"cabbsman","url":"https:\/\/community.smartsheet.com\/profile\/cabbsman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!88cq90f5xTs!8sDpd7uL9Ps!kj4X4avpgGN","dateLastActive":"2023-06-30T15:02:28+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-06-30T15:01:12+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":31,"score":null,"hot":3376213174,"url":"https:\/\/community.smartsheet.com\/discussion\/107109\/bridge-workflow-runs-with-no-errors-but-doesnt-copy-data-to-column-am-i-missing-modules","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107109\/bridge-workflow-runs-with-no-errors-but-doesnt-copy-data-to-column-am-i-missing-modules","format":"Rich","tagIDs":[369],"lastPost":{"discussionID":107109,"commentID":383333,"name":"Re: Bridge Workflow - Runs with no Errors but doesn't copy data to column. Am I missing modules?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383333#Comment_383333","dateInserted":"2023-06-30T15:01:40+00:00","insertUserID":91566,"insertUser":{"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-06-30T15:01:12+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/G9744765U09U\/screenshot-28106-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot (106).png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T14:52:58+00:00","dateAnswered":"2023-06-30T11:53:00+00:00","acceptedAnswers":[{"commentID":383292,"body":"

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

It looks like you're using the Update Column module, which would update column properties<\/em> (e.g. what elements appear in a dropdown list to select, or changing it to a Contact type of column). <\/p>

Instead, use <\/strong>Update Row<\/strong> (see here)<\/a><\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

You'll want to add the Data Reference from your Get Row call to input the Sheet<\/strong> and the same Row ID<\/strong>.<\/p>

Then under Cells<\/strong>, use the Key to identify the column and the Value can be pulled from the Run Log of your Get Row module. <\/p>


<\/p>

Let me know if that makes sense and works for you!<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts