-
Sheet Summary CountIFS + Date Range
Hi All, Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not. Background: Form was converted over from Google Form/Sheets & several formatting changes had to be made in August. (Probably issue #1) Co-workers…
-
Variance on task list
I have a sheet that is a running list of tasks that gets added to weekly. I am looking to figure out how to show how early, or late, a task is completed in relation to the due date. If the task is on time, I want to show 0. I have been trying to use this formula =NETWORKDAYS([Due Date]@row, [Actual Finish]@row) - 1 This…
-
Is there a way to easily/quickly hyperlink 100's of sheets.
I am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink and go directly to that person's individual sheet. I understand that the desired effect can be obtained by running a report…
-
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)
