-
Create a list from check marks in a grid
I need to pull data from a grid organized like this (with yellow items being being column headings): into a list that is structured like: I am stumped on how to do it. I do not own the original data so I cannot restructure it into a different form. Any tips? -Matthew
-
SUMIFS with Multiple Conditions and Two Children Rows
Hi! I'm trying to work out the SUMIFS formula for a summary sheet based on multiple criteria that will SUM from two different children sum rows. Row 3 and Row 42 have the SUM(CHILDREN()) formula in those columns. I can do it for one child row with the below formula for each but i need to add the two together.…
-
SUMIFS I think?
I am trying to count a total number of employees in a multi-select drop down and also only count those employees if they attended meetings in November, December, January, Etc. All of this data is absorbed via a form. My current formula is: =SUMIFS([Employees at meeting]:[Employees at meeting], >1, Date:Date, AND(@cell >=…
-
Formula to return different values
Hello, I am trying to write a formula to return one value if a certain criteria is met, and a different value if that criteria is not met. What I have is below. It's not working, but I'm not sure how to fix it. Any ideas? =IF(Dates@row <= $Dates$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), ""),…
-
FORMULA FOR IGNORING A BLANK CELL WITHIN A COLUMN WITH FORMULA SET
Hello, I want to count the number of days from task set vs the due date set. I know the formula for that which is NETDAYS however, on empty spaces that I don't want filled in, INVALID DATA shows. So I want to know how to ignore the formula on blank cells. Can someone help me please? Column names: Original End Date, New End…
-
Sheet Name within a Cell
Hello, I was wondering if it is possible to write the current SS Sheet name to a cell that you are working on? The reason that i am checking this functionality is due to how certain project plans are created within a Workspace and i need to filter out within a report. Thanks, Anthony
-
CountIf with Multiple Criteria + Mutli-Sheet Reference
Hello, I am trying to count total items in "Medium" item in PRIORITY Column that also have a status of "Done" in the STATUS Column. Both PRIORITY and STATUS columns are in the SCRUM: Communications sheet. Here's my current formula (which is reciving a #INCORRECT ARGUMENT SET error): =COUNTIF({ SCRUM: Communications…
-
IF Statement
Hello! I was wondering if anyone could help get me started on carrying out what I think will be a very long IF/AND statement. See attachments - I've created a formula to read the department column and the output will be the employee that has been entered into the top grey section in the Assigned To column. My issue is that…
-
Using AND with IF to check two text fields
Hi All, I am trying to create a formula in a sheet that references a range from another sheet to work out IF 2 text conditions are true but not sure of the syntax. Can I get some help please with my attempt below; Range 1 is a single select drop down using text Range 2 is a single select drop down using numbers 0-10 I want…
-
Return Column Names AND values from row in a reference column
I'm trying to figure out how to return the columns and values found in them for any given row. I have approximately 200 unique columns that are populated from a web form if/when the column is relevant. individual rows track construction items completed. Each row identifies crew, date, job number, etc., and the remaining…