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…
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…
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…
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…
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,…
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…
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…
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…
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…
