Health Care

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Health Care

 

Discussion List

  • Michael Palko
    Michael Palko 10 views 0 comments Started by Michael Palko Formulas and Functions
    First post 01/22/20,Last post 01/22/20
    I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) …
    Formulas and Functions100
    Michael Palko
  • hlu3680451
    First post 03/01/19,Last post 01/17/20
    Hi, I am a business license user, recently, I shared the report to the people. some of them feedback, since we forget the password, when they tried to reset passowrd by click" forget password", they got the message “ the request…
    Using Smartsheet285
    hlu3680451
  • benfking
    benfking 30 views 4 comments Most recent by Andrée Starå Using Smartsheet
    First post 11/13/19,Last post 01/16/20
    I am wanting to create an approval workflow that requires different levels of approval. The number of levels depends on where the request is coming from. As an example request comes in that requires Director, VP, and CEO approval to procee…
    Using Smartsheet304
    benfking
  • Paul Hogfeldt
    Paul Hogfeldt 42 views 6 comments Most recent by Andrée Starå Using Smartsheet
    First post 06/20/18,Last post 01/15/20
    Hello, I see that there are many other threads requesting this feature but nothing recently from Smartsheet staff saying whether or not this request is being taken seriously. Does anyone know if there are any plans at all for this to be a…
    Using Smartsheet426
    Paul Hogfeldt
  • Amanda Chu
    #INCORRECT ARGUMENT SETAccepted Answer
    Accepted Answer Amanda Chu 240 views 15 comments Most recent by Andrée Starå Formulas and Functions
    First post 03/13/19,Last post 01/13/20
    Hello, I cannot figure out why this SUMIFS is not working. When I break up the SUMIF criteria, they both work fine. But when I put them together, I get #INCORRECT ARGUMENT SET error message. =SUMIFS({MH Client Profiles v2 Range 13}, &quo…
    Formulas and Functions24015
    Amanda Chu
  • David Skinner
    David Skinner 72 views 9 comments Most recent by Paul Newcome Using Smartsheet
    First post 08/21/18,Last post 01/08/20
    Has anyone received this error message before?  What are the options for large data?   (Image)
    Using Smartsheet729
    David Skinner
  • Zachary Mitchell
    Answered Zachary Mitchell 18 views 2 comments Most recent by Mike L. Formulas and Functions
    First post 01/02/20,Last post 01/02/20
    My organization (a small physicians office) is creating a new onboarding check list via smartsheet. We want to update the staff on certain tasks they need to complete for new staff members going through the process. I've considered a few o…
    Formulas and Functions182
    Zachary Mitchell
  • Chris Trumpey
    Chris Trumpey 35 views 1 comment Most recent by Genevieve P. Formulas and Functions
    First post 12/06/19,Last post 12/08/19
    Hi All, I need some CountIFS help with counting dates, I have a sheet that has a column called Device that has either New or Existing. Then my second column is Date Installed. If the Device is New and the Date Installed has a date then I …
    Formulas and Functions351
    Chris Trumpey
  • KDub618
    KDub618 35 views 2 comments Most recent by Paul Newcome Formulas and Functions
    First post 12/04/19,Last post 12/05/19
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    Formulas and Functions352
    KDub618
  • skarkhoff
    skarkhoff 20 views 1 comment Most recent by Paul Newcome Formulas and Functions
    First post 12/03/19,Last post 12/04/19
    I'm sure this is simple, but I've searched for a while and haven't found anything similar!  I have a sheet set up to track each piece of marketing collateral.  It starts w/ the beginning quantity (say 100 pieces) and deducts the number of…
    Formulas and Functions201
    skarkhoff
  • Paulla Miller
    First post 11/14/19,Last post 12/03/19
    I would greatly value any feedback on the use of SmartSheets for Case Management and Outcomes.  We are currently looking for systems that can be used for tracking purposes on successes.  One is as easy as tracking of specific goals from a …
    Using Smartsheet192
    Paulla Miller
  • lwatts
    lwatts 24 views 4 comments Most recent by Andrée Starå Using Smartsheet
    First post 11/26/19,Last post 12/03/19
    Hi, We're about to implement a new EMR system at our clinic system.  Was wondering if anyone else has done this with Smartsheet.  Would like to hear about lessons learned, how you used Smartsheet etc.  Thanks!  Linda
    Using Smartsheet244
    lwatts
  • Ben Donahue
    Ben Donahue 14 views 6 comments Most recent by Andrée Starå Formulas and Functions
    First post 11/18/19,Last post 12/02/19
    WHAT I'M TRYING TO DO: I would like to accomplish two things in one IF statement. Something like: =IF([This Column]@row = 1, [That Column]=true ALSO Today(), ....) WHY I'M TRYING TO DO THIS: I am trying to automate the Actual Finish co…
    Formulas and Functions146
    Ben Donahue
  • Nillie D
    First post 11/30/19,Last post 12/02/19
    Hello  My organization has finalized our 2020 Capital Ex Budget. Starting in January 2020, I want to create a Capital Exp Form that provides the options that were approved for the 2020 Cap Ex Budget. For example, the form would be set up …
    Using Smartsheet221
    Nillie D
  • Michael.Baker
    Closed Michael.Baker 20 views 2 comments Most recent by Ford Archived 2017 Posts
    First post 08/07/17,Last post 12/01/19
    My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula.  Are we missing something; Why is the SS math library so dumbed down?  Below is the formula in E…
    Archived 2017 Posts202
    Michael.Baker
  • @CollabMeganPMP
    @CollabMeganPMP 74 views 46 comments Most recent by Ezra Using Smartsheet
    First post 10/15/19,Last post 11/26/19
    I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more contex…
    Using Smartsheet7446
    @CollabMeganPMP
  • Melany  Tenore
    Melany Tenore 29 views 4 comments Most recent by Andrée Starå Using Smartsheet
    First post 11/25/19,Last post 11/26/19
    Hi - I have been searching through old posts and I see many mentions of a new feature that's hopefully coming soon to be able to track time in a column (24 hour format would be great). Any update as to when this may be available? Thank you…
    Using Smartsheet294
    Melany Tenore
  • dzenus
    dzenus 26 views 4 comments Most recent by Andrée Starå Using Smartsheet
    First post 11/25/19,Last post 11/25/19
    I need to create an approval workflow where 2 criteria need to be met but it seems the only option is "or" and not "and" (see screen shot).  Is there a way to have an approval sent out only if both criteria are met?   …
    Using Smartsheet264
    dzenus
  • James Cronin
    Closed James Cronin 115 views 16 comments Most recent by vdiaz Archived 2016 Posts
    First post 03/29/16,Last post 11/25/19
    I have a new requirement to have more than attachment field in a web form. Example: the form asks for specific budget information in one section requiring upload(s), and then in another section we would like to add an area to add receipt i…
    Archived 2016 Posts11516
    James Cronin
  • Paula Cosentino
    First post 11/20/19,Last post 11/22/19
    We have a gremlin!  There have been two instances now where we manually move a row, smartsheet appears to be moving it, then it ends up back on the original smartsheet.  The activity tracker shows the attempts on both smartsheets.   Any id…
    Using Smartsheet155
    Paula Cosentino
  • Emerus CCC
    Emerus CCC 17 views 8 comments Most recent by Andrée Starå Using Smartsheet
    First post 11/19/19,Last post 11/20/19
    We are currently having issues with lines being overwritten when more than one team member is entering information into a sheet at the same time.  Anyone else experiencing these issues?
    Using Smartsheet178
    Emerus CCC
  • NaNa
    NaNa 36 views 4 comments Most recent by Paul Newcome Formulas and Functions
    First post 11/20/19,Last post 11/20/19
    So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have…
    Formulas and Functions364
    NaNa
  • wboyle111121
    First post 11/13/19,Last post 11/18/19
    Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc.  Key notification criteria is based on start and/or end dates. Currently, their notification is setup to …
    Using Smartsheet263
    wboyle111121
  • Iz
    Iz 16 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 11/14/19,Last post 11/18/19
    Hello All, I have been a huge fan of the "recently opened" Navigation tab and have about 30 sheets pinned.  I do use various sheets at various times, however, and would like to rearrange the order of these sheets as well as be a…
    Using Smartsheet161
    Iz
  • 100
    Closed 100 27 views 3 comments Most recent by Paulla Miller Archived 2017 Posts
    First post 01/20/17,Last post 11/14/19
    are there any Biotech or Pharma companies using Smartsheet that I can speak with regarding setting system up.  Our finance group set the system up to track POs & Invoices, however Clinical needs the system to incorporate timelines and …
    Archived 2017 Posts273
    100
  • abrown
    abrown 23 views 2 comments Most recent by Paul Newcome Using Smartsheet
    First post 11/12/19,Last post 11/13/19
    Hello All, I was wondering if anyone has found a way to have a link/button in a subsection of their project plan (for multiple different lines in the plan) where they can click and bring up a blank meeting minutes form for a call, complet…
    Using Smartsheet232
    abrown
  • Cary_2207
    First post 11/12/19,Last post 11/13/19
    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…
    Formulas and Functions701
    Cary_2207
  • Shah_0614
    Shah_0614 22 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 11/06/19,Last post 11/07/19
    I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address.  I would like to create workflow automation when a certain trigger has taken pla…
    Using Smartsheet221
    Shah_0614
  • KMan1190
    KMan1190 18 views 3 comments Most recent by Genevieve P. Formulas and Functions
    First post 10/31/19,Last post 11/06/19
    I'd like to create a formula which only counts the Rows in which a date in a particular column is in the last 30 days (among other criteria) =COUNTIFS({Referral Source}, "Elm", {Database Status}, "Green", {Database D…
    Formulas and Functions183
    KMan1190
  • Ben Donahue
    First post 10/22/19,Last post 11/01/19
    I have previously asked a similar question, but with fewer requirements. I am trying to return the Task Name associated with the lowest number in a helper column that is >0. With some help from [email protected], I was able to get close, I think,…
    Formulas and Functions1610
    Ben Donahue