-
How to deselect a radio button answer option in web form?
Is there a way to allow a user the ability to deselect (or unselect) a radio button option after making that selection (i.e., clear out their choice and make no selection after already having made the selection?)
-
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…
-
CRM - Specialty Pharmacy
I am looking to create a CRM solution for a specialty pharmacy initiative as a bridge to formal CRM platform integration/implementation. The ability to track patient-specific information and recall data as well as fills within the same space are key. Looking for best practice and build suggestions if possible.
-
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…
