-
Sum Column results when filtered
I want to sum numbers in a column of all the vendors. If I filter out certain vendors I want the sum to be only of the vendors showing. How do I do that?
-
Resource Planning: Calculating Weekly Hours Remaining for a Project
Hello, Goal: To view estimated hours per resource per week. I am looking for a way to calculate the weekly hours remaining on a project, per person. I am referencing my project plan as the source sheet which has: Resource Name, Estimated Hours, Start Date, Due Date, Week Start, Task Name, etc. In a summary sheet, I would…
-
Dynamic file name creation with formula
Current formula is below. I get an extra hyphen between project name and size if the row is a level 2.or 3. I can't figure out how to not have an extra hyphen. Not sure if I need to add OR statement so it looks at each level then pulls the correct information. The file name should be Job#_Project Name_Size =IF(Level@row >=…
-
if statement based on another column
Hello All, I am trying to figure out the best way to create an if statement. In my column RML Status if the status is RML-Current or In-TRL Current I would like my helper column to state ACTIVE. If it doesn't have either of these two status', I would like it to state INACTIVE. How would I go about creating this the…
-
Star if Several Criteria Match
I want to Star the cell if the center at row matches any of our centers. The formula I am using: =IF([Center]@row = "Carville", 1,IF([Center]@row = "Centennial", 1,IF([Center]@row = "Charleston", 1,IF([Center]@row = "Clearfield", 1,IF([Center]@row = " Earle C Clements", 1,IF([Center]@row = " Edison", 1,IF([Center]@row = "…
-
Reference Another Sheet
Hi all, I am very sorry that I have to call for your assistance but finding the answer is not really straightforward. I have a formula that works, yahoo! but it works if I keep it on the same sheet. Now I want to use this formula that use all the data form another Reference Another Sheet (RAS). Do I have to add the RAS for…
-
I need to Sum a column from a reference sheet and display the number in my primary sheet
I am attempting to build a column formula that generates the sum of hours for a given phase (task). This is an interaction of our Main project grid and the Timesheet grid (it is one of the advanced reports Resource management offers) from Resource Management. Our main project should display the number of hours incurred for…
-
Using a multi-select column in reports.
I have a sheet with a multi-select column (Plaintiff Law Firms) that I want to group by and count in a report. I have a helper sheet (Plaintiff Firm Helper Sheet) that counts the number of times the law firm appears in the sheet: =COUNTIFS({G6 Active Cases Range 1}, HAS(@cell, [Law Firm Names]@row)) I also have a report…
-
Grouping Averages
Hi! I am trying to figure out a way to group users scores on multiple tests together based on user, and produce an average for each specific user, and overall class. The data is input from a form. Is that possible?
-
Chart
I have a project manager that am working with, and have status, %completed, assigned to-- I want to create a chart in the dashboard that gives me the %completed by assigned to, this way I can see how much they have completed…is there a way to do that? thank you in advance! Enma