-
Opening Dashboard Hyperlinks in new tab.
The dashboards that I've created for out Project Management teams contain a report that lists all their active projects with a hyperlink to a project schedule (A different Smartsheet Grid). I've been asked if it is possible for them to open the schedules in a new tab rather than opening it up in the same tab/window,…
-
Medical Publication Tracking- what is best template to start?
Hello, Any insight to the best Template or Template Sets to use to initiate: --basic tracking for medical publications (ie, manuscript development; congress abstracts & posters & presentations) --with "at risk" elements; or Red, Yellow, Green notifications Thanks!
-
Volunteer Allocation
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 locations (we do not know these specific locations until last minute). I have built a survey…
-
New Electronic Medical Record rollout
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
-
Smartsheet to Harvest Integration-Exporting to multiple users time
My team was very excited to see Smartsheet can connect to Harvest. Currently, we have one project with multiple freelance workers. When I exported time for other project team members all their time appeared on my time sheet in Harvest. Is there a way to map hours/tasks to multiple individual time sheets for one project?…
-
Gannt chart start date does not match the date column
Hi, Pretty long project, spanning a bit over a year. I'm about halfway through it & the Gannt Dates started getting weird. In the image, Look at "Floors", predecessor 232. The scheduled start date column says 8/13, but the gannt displays the bar starting at 8/14. I dont know if this is related, but the scheduled start…
-
Find all similar entry names and add their qty
Hello I have a sheet I made where I load in all my orders of items needed for a job. Each Item has a code assigned to it I'm calling the Entry Name. There will be times where the same Code/Entry Name will appear several times during the life of the project. For Example This week I might need 4 - BT01 (Entry Name) then as…
-
If Cell is Empty or Blank
Hi, I have created the following formula =IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Pending") > 0, "Pending", IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Created") > 0, "Pending", IF(COUNTIF([PCORI Reports]@row, "Requested"), "Pending", "Done"))) which is working efficiently, but…
-
Automatically move a sheet within a sheet?
Hi. So I have created a production sheet that displays all my projects and where they're at in its state (Phase 1 through Phase 5). For example: Phase 1 Projects: Project 1 Project 2 Phase 2 Projects Project 3 Project 4 Phase 3 Projects Project 5 Each "project" is a hyperlink. When clicked on, it sends the user to the…
-
Update requests for Sheet Summary Fields
Hi Community, hope you are well. Does anyone know how and if it is possible to set an automation that triggers update requests for fields in the sheet summary? The update request function generates an handy form which would be perfect to capture the weekly project status update which as per current set up is located in…
