-
PMO Template Set - Need another level of folders
Hello Gurus, We are in the process of implementing the Smartsheet PMO solution from the template set. We've done some customizations and we think this is really going to meet our needs. One thing we do need is the ability for each PM to see a dashboard for just the projects they are managing. In the template set there is a…
-
Cell linking based on the cell value from the source sheet
Let's assume for a second that I have a file that is titled "Project Info". I also have a folder called "Projects". Every file in the project folder has the same columns though the project names are different. In Project Info, each filled row will have a unique key that references one of the files in Projects. What I am…
-
Automate the copying of rows and deleting previous versions
I'd like to automate the copying of a row into a secondary sheet when a cell is updated. Then delete any older versions, on the secondary sheet. I have already created a system column to create project ID's. I can find previous versions of the copied data, but I'd like to automate it so that when the new information is…
-
Smartsheet Dashboard published within MS Sharepoint 2016
I want to take a Smartsheet Dashboard that is interactive and put it as a web part within MS SharePoint 2016 site. I use the page viewer webpart and provide the web page link offered up when I publish the dashboard, but once I apply it, all I get is the smart sheet blue screen, then the "smartsheet is loading" and the just…
-
Nested If SmartSheet Formula For Symbols (R, G, Y)
=IF([% Complete]@row < 0.7, "Red", (IF([% Complete]@row = 1, "Green", "Yellow"))) i.e. =IF(data < number, "TRUE Symbol Text", (IF(data = number, "TRUE Symbol Text", "FALSE Symbol Text")))
-
Best Method to Track Resource Loading by Individual & Their List of Tasks
Hello, I work in manufacturing and have used Smartsheet in the past and taken advantage of the "issues/task" list template for a specific capital project and modified to fit my needs. It worked great. I set up a very simple dashboard to show status of tasks, # of tasks assigned to each person, etc. However, that was for…
-
Changing a cell's values from code in a different cell
Is it possible to change the value of a certain cell using code in another cell. I would imagine it looking similar to this format.. IF(column@row=X, different_cell=XX, different_cell=XXX)
-
#INVALID VALUE error with collect/index/match/small function
Hi all, Feeling like I've got a real head scratcher here- I have been struggling with this formula creation for the past few days and am hoping that the gurus can help! Within my sheet, I have UniquePart pulling in a list of unique values from a source sheet. The frequency of the part within the source sheet is then…
-
Resource Management - Assignments and regional holidays - what am i missing?
I'm feeling very confused or very swindled. Either way not thrilled right now. I was sold on the promise that Resource Management will be SS's integrated (via add-on) resource planner, where you can apply different roles, placeholders, regional holidays, etc; and that this would all lead to improved task assignments and…
-
I need a formula to calculate projected hours based on start/finish dates
In a project plan we have start date, finish date, and an estimated hours column to track against budgets. I need to be able to identify and total projected hours needed by month. Formula should return and absolute 36 hours for December - populating 20 and 16 in Dec column, 28 hours for January - populating 8 and 20 hours…
