-
Has anyone used Smartsheet to create a User Request Form or User Access Requests Form?
Typically, URFs or UARs have been paper-based. I am wondering if anyone has created and successfully implemented a system to not only track the overall requests but to alert the various people across the organization if they are assigned actions based on the system(s) they oversee. Thank you.
-
Does Smartsheet Support "Schedule Performance Index" (SPI)?
I've seen some past posts where users tried to create their own columns for this, but they seemed to have errors in the way the calculations were done. What is the latest solution from smartsheet (or recommendation from end-users) to have a calculation that works correctly for SPI? It should be SPI = Earned Value/Planned…
-
Program Management within PMO structure
I need to set up a Program (Multiple projects). What is the best way to do this within my portfolio? Set up each project in the program as a separate projects? add these projects as separate sections within one project plan? Ultimate goal is the have a status for the program and have the program report as a status in the…
-
Seattle Based Senior Program Manager, Expert Smartsheet Developer
Hello Everyone! I'm looking for a Program Manager position in the Seattle area, and I hope I can bring my love of Smartsheet to my next position. Please reach out if you know of anything. With a solid track record spanning over two decades in the healthcare and related industries, including a decade of expertise in GMP…
-
Anyone know how to fix this error in Control Center?
Hi, I keep receiving this error when trying to save one of my blueprints in Control Center, the link to the Work App also crashes when I try to open it saying an associated Work App can't be found. When looking at the Portfolio level Work App, I can't see this blueprint linked on there either. The settings for this…
-
Removing a field from the Summary & project sheets
I have a field coming from one of my project sheets feeding to my Summary sheet that's been replaced / is no longer needed. I'd like to remove it but wanted to know if there was anything I should keep in mind. If I just delete the field from the summary sections of all my projects & delete the column in the Summary sheet,…
-
Best Practices/Work Arounds for the lack of "elapsed" and "months" options
I want to open the discussion in this industry forum because I'm certain this would be a group of folks that regularly encounter this short coming. The inability to put "edays" in the predecessors column leads me to a ton of extra rows that serve no purpose other than being a way to get "# edays" in the duration column so…
-
Jira Tickets that have been overwritten during a Jira Connector Sync Error
Hello All, Today, I started receiving abnormal Jira connector sync errors on a workflow that has been working for over a year. I may have received 7-10 or so. The workflow eventually timed out, and the sheet it wrote differed from what it was supposed to look like. This means it pulled in data from other sources in Jira…
-
Can you copy parent row info to child rows within the same column?
I am trying to figure out a formula to autofill a few columns in a child row with information from the parent but can't figure out how to do it without creating new columns. Is it possible to do this within the same column? The sheet is mostly used in card view so when team members add a subtask they will fill in the task…
-
Smartsheet data in Power BI Date fields - Remove Timestamp?
When I import my Smartsheet data to Power BI, the start and end date fields consistently pull with a timestamp that is nowhere in my sheet. I need these date columns to just have dates, timestamps removed entirely, so that I can tell Power BI the data type is "date" rather than "text." Is there a way to do this on the…