-
Formula to check Child Row checkbox if Parent row contains "ABC Dept" (filtering by Department)
I have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows for the individual resources per department. I'm trying to create a filter to filter resources by department across…
-
How to use end date and percentage complete to automate RYG status
Hi everyone, Maybe my brain is struggling with IF and AND statements, but this is defeating me. I am trying to use the end date of a task compared to today's date and the percentage complete (great than or equal to 75%) to drive my status column of red, yellow, green balls. I think I need to find a way to combine the…
-
Calculating an Average based upon a value in other column
I have a calculation to calculate the number of days between two columns. =IFERROR(NETWORKDAYS([Date Submitted]41, [Go Live Date]41), " ") It works great to return a blank if the customer has not gone live. Then I have formula to calculate the average of the cells. =AVG([Number of Days to Implement]12:[Number of Days to…
-
Calendar View and Reporting
One of the project managers I work with prefers to work in a calendar view for the reports. I included snap shots of our Project Template, Report and Calendar View. Our process is to open a project template and name according to the meeting. Example: "Store Celebrations" From there the Dates are added and adjusted based on…
-
Work Breakdown Structure (WBS)
Are there any plans to add the ability to display a graphical (hierarchical boxes) WBS? Stephen
-
Formula for taking an average of duplicate rows
I'm attempting to construct a formula for taking averages of multiple ratings from several raters across three vendors. Sheet 1 looks like: Rater - Category - Vendor A Rating - Vendor B Rating - Vendor C Rating Sheet 2 looks like: Category - Vendor A Rating Avg - Vendor B Rating Avg - Vendor C Rating Avg On sheet two, I…
-
SUM and IF In the same Cell
Is it possible to have a cell include both a SUM and IF statement to do the following. (I do not want use a separate status column.) I want to be able to add up several columns (Actual Admin Labour + Actual Engineering Labour + Actual Mechanical Labour) into a Total Actual Labour column and then add an IF statement that…
-
Create Hierarchy Relationship using WBS and Formula?
Hi, I believe this may be a bit of a stretch but I am wondering if it is possible to automatically create the Child/Parent relationship utilizing the numbers or periods in a WBS # column as a way to automatically create the indention. I have built a pretty good process using Smartsheets data uploader to import external…
-
INVALID OPERATION in one column but not the other
Hello, I have the below formula in three columns in my sheet. They are all referencing the same master sheet, same dates, same facility, same units, but different utilization rates. Two of the three columns are working great. The last one isn't. I re-typed the formula in several times, following the other columns' formula,…
-
How to count how many users assigned to in a sheet
Hello, I have multiple projects and each project is in its own sheet. I am trying to create a summary sheet (to later show in the dashboard) that shows how many people are assigned to each project currently. Is there a formula for this or a feature? Thanks