-
Aggregate Summary Field Data from Multiple Sheets
I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management. See word doc for details Any suggestions to the best approach appreciated.
-
Is there a way to auto-hide columns based on the value selected from a drop down cell?
I have a main grid with several columns and a webform that feeds into that grid. This tracker is used by my team to track several job "types" defined in one of the destination grid columns as "Large Project", Medium Project" and "Small Project". Each distinction has its own requirements, thus making a few of the existing…
-
Test log
Can someone provide some insight to creating a testing log? Either point me to an existing Smartsheet template set that can be massaged to fit my testing needs or have a test log template set that you are willing to share.
-
Counting completion status off of a group of sheets
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am trying to figure out how to pull together a dynamic number for the total number of courses…
-
Color Coding for Names / Owners only
I'm trying to find out if I can color code only the name bubble. For example, below I'm using the multiple-drop down column formatting and all names are shown in grey. It would be nice to show Whitney in purple, and Laura in yellow, so that they can quickly see tasks they are assigned to. Right now, I can only set a…
-
COUNTIF in Sheet Summary
I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error. =COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")
-
count tasks per week number
Hi community, I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year. Here is my formula that calculate 0 every time (at least not an error) : =COUNTIF({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER({6530 - Sulfuric project…
-
Subtracting dates
I have a start date of 10-1-19 and a stop date of 10-31-19 and I want to see how many working days are in the range. I am using the formula as follows: =NETWORKDAYS([Schedule start]1, [Schedule stop]1,) I keep getting #UNPARSEABLE Must be doing something wrong? Regards, ds
-
Create formula to count category risk with aggregate rating
Hi, I have a risk register for a project that has well over 100 risks documented and I have them categorized into 17 different risks. I would like to be able to create a formula to count how many risks exist under each category and then a formula to show the aggregate risk associated with this. I would think by a…
-
Cell values export from one project to another
Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with every changes in the master project and provide up-to-date information during meeting. I would like to add curves to the…