-
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…
-
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…
-
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,…
-
Starting from scratch.
Hello community! I am new to Smartsheet and I am trying to work on a my Hospitals volunteer databases to bringing the 3~4 different programs that we have running into Smartsheet. We have one for each of the following; volunteer onboarding/application tracking, annual learning, volunteer time and location tracking, and…
-
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…
-
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…