-
Excited to connect with the Health & Life Science Smartsheet Community! 👋
My journey started in medical coding and compliance, where I had the privilege of working with medical schools and even contributing to Epic's coding software design. Today, I'm a Change Management Strategist and Smartsheet expert passionate about helping biopharmaceutical companies and smaller medical groups leverage…
-
Excel @Text() Functionality in Smartsheet?
Is there a way in Smartsheet to use a formula that gives the same result as using @text() in Excel? I have a spreadsheet that I need to concatenate several fields together and have the field then display as text. Most of what I see now for formulas is to covert from text into formula. But I need to go the other way? Use…
-
Brand new interactive HLS Solution Catalog!
Hello all! I'm one of the solution engineers, and a provider myself (physical therapist), who helped develop this new HLS Solution Catalog. It interactive so you can drill into the solutions a bit (click on the images) to see a few of the use cases we commonly see. It's ever growing so continue to check back! What use…
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
Daily Automated Report
I am a dead beginner with SmartSheets and I am self taught thus far so explain to me like I've never seen a computer before :) Our hospital holds daily huddles where each department reports out on questions specific to their unit (current paper form attached). I’ve created a sheet that includes all the questions to be…
-
VLOOKUP and COUNTIFS
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
-
Linking Sheets - Master sheet with multiple related sheets
Hi! I am looking to create a master sheet that contains personnel data elements used by multiple teams with different needs. The master sheet should allow data entry of new attendees while also pulling new entries from a related travel sheet. Example: Master Sheet Admin is aware of a new registrant and manually adds to the…
-
Hello fellow Healthcare & Life Sciences folks!
I am newer to the Healthcare Industry, but I love it. I am the Administrative Assistant at our corporate office. We have 13 free-standing Emergency Rooms, and 1 Urgent Care facility. I am the creator and implementor of all things SmartSheet for our company, all facilities use the forms and audits we have. Sometimes when I…
-
More Robust Backup Platform
There have been many requests for a more robust Data Backup/offload system because the existing system is inadequate. Smartsheet is simply not a viable option for data management in regulated spaces until: 1. Backups are more easily automated (Can't you just make a Data Shuttle checkbox to prevent replacement of previous…
-
Can a copy of form responses automatically be sent to multiple emails after a user completes survey?
Hello, I work in medical education and am looking for a way to have the results of a filled form automatically sent to multiple emails. Essentially the problem I am attempting to solve is this: We are looking to have medical students receive instant feedback from their faculty supervisors through Smartsheet. Ideally,…