Healthcare
Discussion List
-
Displaying multiple "dates" in calendar view from same rowIn Using SmartsheetGood 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…
-
OneNote integration in SmartsheetIn Apps, Integrations, and Add OnsBased 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…
-
Digital SignatureIn Using SmartsheetHi 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…
-
Formulas with Drop-down Multi-Select ColumnIn Formulas and FunctionsHi 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…
-
Multisite Clinical ResearchIn Using SmartsheetHello, 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…
-
Combined IF AND formula with rangeIn Formulas and FunctionsGood 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 …
-
AVERAGEIF value between a date rangeIn Formulas and FunctionsHello, 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 …
-
COUNTIFs formula with Date RangeIn Formulas and FunctionsHello, 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…
-
Census Information for a companyIn Formulas and FunctionsIs 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 views 4 comments 0 points Most recent by Marvin Daniels Formulas and Functions
-
Send alert to task's assignee when predecessor task's status changes to completeIn Formulas and FunctionsHi 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 …
