-
Row Report - Column Summary but also need an average
Hello- I have a Row Report - with column summaries- I've attached a snippet of the Row Report to show an example. The column totals are at the top. And for example, in the 2nd & 3rd columns it's listed as Ind #1 Expected & Ind #1 Completed - so the total is 50/53 but I was wondering if there is a way to also get the…
-
Merged: Add Save and Resume Later Option for Forms
This discussion has been merged.
-
Looking for Tips on Building Smartsheet Buy-In
Hi everyone, Our department is still relatively new to Smartsheet, and overall, the rollout has gone well — most team members have been enthusiastic and quick to get on board. We’ve also had a few internal champions who’ve helped drive early adoption, which has been a big help. That said, we’re seeing a bit of hesitation…
-
Solution Spotlight (HLS)- Dynamic View for Insurance Verification & Accreditation Processes
Hello all! On Tuesday, 1/7/25 at 11:30am PST/2:30 EST the Healthcare & Life Science (HLS) Solution Engineers are putting on a Solution Spotlight Demonstration of two unique solutions utilizing Dynamic View to securely control data. The registration dashboard is here (no account required, and even if you can't attend we…
-
Join us for a Accreditation Survey Prep & Survey Tools Community Call - Dec. 5 @1:30pm EST
Missing the excitement from Smartsheet Engage? We are too! Let’s keep the momentum going! Join us on December 5, 2024, from 1:30–3:00 PM EST / 10:30–12:00 PM PST for an exclusive Community Call featuring Regina Shelnutt, Accreditation Manager at Tanner Health. Regina will showcase her innovative Smartsheet solution for…
-
Cell Changed Color When Formula Updated
I just updated a date cell formula to give someone a little longer to complete a list of tasks and they all turned yellow. It' not a cell filled color because you can't remove it. I have updated this formula before and not had any issues with the box changing colors, so I can't figure out why it's doing it now. It's a…
-
Is there a class/how to guide someone would suggest when using the policy template?
I am new to Smartsheet, but catch on pretty quickly. I did not find anything in the university.
-
What topics would you like to see in a future HLS Solution Spotlight?
👋 Hey there, HLS Community! We're gearing up for our next Solution Spotlights and need your input. As a dedicated healthcare and life science professional, you tackle challenges daily; we're curious to know: What burning questions or use cases do you want to explore more? Which topics would empower you to reach new heights…
-
Print completed forms without Business Plan
Hello! I am the sole Smartsheet user in my company (I'm trying to bring them along, but so far I haven't gotten with the right decision-maker). The main reason I use this at this time is for training and in-service acknowledgments. I used Smartsheet at the enterprise level with a previous company and convinced my current…
-
💡 Healthcare & Life Science August Solution Spotlight - Opex & Strategic Planning
🖐️ Hey there Smartsheet Community! We have an exciting Solution Spotlight on August 14, at 1 pm EST / 10:00 am PST. In this Solution Spotlight, we'll explore how Smartsheet can help you seamlessly integrate Accreditation Management, Project and Portfolio Management, Mergers and Acquisitions, and Sourcing / Procurement to…
-
Want Dashboard to Update with Data Live Based on Report
Hi - I want a dashboard I have created to update with data live based on the report I have input into the dashboard. Is this possible, by which I mean can a sheet update live based on a report so the metric widget reflects those numbers? If not, what are other solutions, and if a formula is needed can you give me the…
-
Solution Spotlight- New Employee/Provider Onboarding
Hello HLS Community! On Thursday July, 11th @ 10am PST our Solution Engineering team will be putting on a Solution Spotlight on how to optimize new employee/provider onboarding! You can register through this Smartsheet dashboard (no account required) There you will find the registration link, topics, resources, and…
-
Solution Spotlight- Healthcare Capitol Construction Demo
Hello all! Our Commercial Solution Engineering Team is hosting a demo of a capitol construction solution on June 25th at 11am PST. Here is the published Smartsheet Dashboard if you are interested in registering! If you can't make it, but still register, we can send out the recording. We also have a special guest, Neil…
-
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…
-
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…
-
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…
-
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…
-
Card View Details Window - Make it non-modal
Please make the details window in card view non-modal. That is, make it so that it docks to the right-side of the screen and stays open while I click through my cards in the other part of the view. This would bring your details pane up to par of what Asana and Jira have available. Currently the detail window is modal and…
-
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…
-
Basic Formula
Two different equations are being used. Equation 1: =IFERROR((SUM([RN Section 1 Score]@row, [RN Section 2 Score]@row, [RN Section 3 Score]@row, [RN Section 4 Score]@row)) / SUM(IF([RN Section 1 Score]@row = "-", 0, 0.3), IF([RN Section 2 Score]@row = "-", 0, 0.3), IF([RN Section 3 Score]@row = "-", 0, 0.2), IF([RN Section…