-
How can I make start dates update automatically when tasks are late
Hi! How can I automate the start date of a task to be updated if the previous task runs late? If someone runs late, it makes everybody else automatically overdue for their task. There has to be some way that it can auto update.
-
Building a summary table from another sheet
Hi I'm creating a sheet "Summary Stats" from a base sheet called "Sheet 1" Sheet 1 has many columns but of interest is The alerts can be "100% Storage", "90% Storage", "80% Storage" I want the populate the Summary Stats sheet to look like this based on WeekOf, total Alerts, # of 100%,90%,80% alerts. I tried a report but I…
-
How do I summarize text data from multiple cells into one cell only if criteria is met in each cell?
I am sending a form out to associates in which I ask them to rate their familiarity with multiple subjects. The 3 available choices for them to choose from are: Very Familiar, Somewhat Familiar and Not Familiar. I would like to summarize their responses from multiples cells (Sales Orders, Invoicing, Stock Status, Purchase…
-
Index/Match with cross sheet references
I have four sheets that I want to summarize in a separate sheet. If I am using an Index/Match formula, can I apply it to Child rows also? On my sheets, I have an amount columns, but some amount cells are sums of the two children rows beneath it. So, when I use the Index/Match formula, it only applies to the main Parent…
-
CountIF with multiple options?
I have a formula that needs to meet 3 criteria, but the 3rd criteria has 3 different options that it has to be ONE of. Referencing a source sheet, here are the criteria I need: Processing group = "Desking" Style Ready = "Yes" Status = ONE of these: "Reviewd - Non-clusterable" "One-to_one" "Clustering complete" I can only…
-
Need to do a contains collect collaboration but unsure if possible
Basically I have two sheets and am trying to get information from sheet A into sheet B In sheet A, I have two columns. Column one contains number e.g. "123 456 789" and column two tells me if the row is approved, pending, or unapproved. In sheet B I need to know what column two is saying in the row where column one…
-
Formula Help - average of the sum of cells in a row if another row in the column meets criteria
Hi, I was hoping someone could help me write a formula? I am trying to write a formula in the cell highlighted in yellow that takes an average of the sum of the cells highlighted in green if the country in row 3 in the same column is set to CANADA. Is there a way to combine a (INDEX) statement with an AVERAGE IF formula?
-
Multiple Criterion to Display Value from 2 sheets
Hi! This is my first time asking some question here I'm having trouble on coming up with a formula for what I want to do. I have two sheets. 1st sheet contains MONTH column, YEAR Column and INVOICE VALUE Column 2nd sheet is where I will be putting the INVOICE VALUE to each month of the year. They both have Row ID so that I…
-
SUMIFS Exclusion Criteria Causing #CIRCULAR REFERENCE Error
This discussion was created from comments split from: SUMIFS excluding criteria.
-
OR function referencing other sheets with Index - returning INVALID COLUMN VALUE
This is driving me nuts. Sheet1: {Sheet1_CC} = Course Code (Text/Number Column) {Sheet2_MRC} = Modify Replace Code (Text/Number Column) {Sheet1_AT} = A Task Dropdown list with restricted options (NEW, MODIFY, REMOVE) Basically a course code can be in either column and I need to pull relating task into Sheet2 Sheet2:…
