Healthcare

 

Discussion List

  • Displaying multiple "dates" in calendar view from same row
    In Using Smartsheet
    Good morning, I have date columns created for the 5 milestone dates that each task/row can be assigned. Is there anyway to get all Milestone dates (date columns) to display in the calendar view.  I have set up color codes to help determine…
    631 4
    631 views 4 comments Most recent by Genevieve P. Using Smartsheet
  • OneNote integration in Smartsheet
    In Apps, Integrations, and Add Ons
    Based on a suggestion I read on this board, I am posting a product enhancement request I just submitted for the community to see. Request OneNote integration in Smartsheet to easily paste in a link to a OneNote page/paragraph/section/sec…
    3913 11
    3.9K views 11 comments Most recent by Ben Hurst Apps, Integrations, and Add Ons
  • Digital Signature
    In Using Smartsheet
    Hi all,   I've searched for this topic, but i could not find directly what  i was looking for. Is there on Smartsheet any functionality for digital signature that doesn't require pairing our service with another software? All the solut…
    4117 11
    4.1K views 11 comments Most recent by Primoz Using Smartsheet
  • Formulas with Drop-down Multi-Select Column
    In Formulas and Functions
    Hi there! I have been using the new functionality of the "Drop-down Multi-select" column and I am trying to capture all of the different combinations that can be selected within the column. The column is supposed to capture the…
    1265 3
    1.3K views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Multisite Clinical Research
    In Using Smartsheet
    Hello, I am new to smartsheets and use it for work here, in the healthcare field. I am trying to figure out the best way to utilize smartsheets to track productivity for a multisite clinical trial. I have found some articles describing how…
    Answered - Pending Review
    31 1
    Answered - Pending Review 31 views 1 comment Most recent by Julio S. Using Smartsheet
  • Combined IF AND formula with range
    In Formulas and Functions
    Good afternoon, I am trying to return values in a cell based on data in another cell as it falls between a range Here is the range: 1 Star 299 - 966 2 Star 967 - 1160 3 Star 1161 - 1330 4 Star 1331 - 1509 5 Star 1510 - 2300 I've gotten …
    Accepted
    14 2
    Answered ✓ 14 views 2 comments Most recent by Paula Meunier Formulas and Functions
  • AVERAGEIF value between a date range
    In Formulas and Functions
    Hello, I am creating a metrics sheet that cross references an archive sheet and am looking to pull statistics within monthly ranges. I want to return a monthly average of the Total ADL Score within a monthly range which is determined by …
    Accepted
    14 2
    Answered ✓ 14 views 2 comments Most recent by Paula Meunier Formulas and Functions
  • COUNTIFs formula with Date Range
    In Formulas and Functions
    Hello, I am trying to create a monthly trend report. The report function is not specific enough for what I need, so in order to do this, I have created a metrics sheet that references 21 different originating sheets. To fill my metrics sh…
    Accepted
    43 11
    Answered ✓ 43 views 11 comments Most recent by Paula Meunier Formulas and Functions
  • Census Information for a company
    In Formulas and Functions
    Is there a way to add and delete employee info with an automation and formula. I need to get accurate count of how many people are in the company and what tier they fall into. I would like to have an up-to-date sheet. Updated Census She…
    Answered - Pending Review
    40 4
    Answered - Pending Review 40 views 4 comments Most recent by Marvin Daniels Formulas and Functions
  • Send alert to task's assignee when predecessor task's status changes to complete
    In Formulas and Functions
    Hi all. New, enthusiastic user here hoping for some guidance. In setting up a repeating process, I have dependencies/predecessors clearly identified. Wonderful! Now, how does one set an alert/notification to auto-send to a task's assignee …
    453 5
    453 views 5 comments Most recent by Paul Newcome Formulas and Functions