-
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…
-
Is there a way to use a formula to tell my contact cell to populate based on another field?
So, I have my team member names populating in the sheet with just their initials - but I want to be able to tell the sheet that if those initials are in the "team" field, then add this matching contact to the "Assigned to" field. Is there a way to do this? I can drag the names down, but just was hoping for an automation
-
Referencing the last comment to update a column
Hi Community, I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet. I'd still like to use the comments thread so other Project Stakeholders can reference the communication for each…
-
Why is my multiplication formula invalid?
I am trying to create a column that multiplies the total hours by the pay rate of certain staff. In the pay rate column I have used the formula =IF(Name1 = "Sophie", "25.54", IF(Name1 = "Peta", "55", IF(Name1 = "Stephen", "55"))) This formula works well, however if I then try to use those values in another formula is just…
