-
Count, Children, Status
Hello, I wanted to create a report/dashboard that showed the total number of items under a parent and how many of those items were in a non-green status. I am entering my formulas on the Sheet Summary section. I have created the formula for count of children but am having a hard time showing count of those children with…
-
Formula Error/Mistake
Hi all, I have a formula that autopopulates only certain cells. Now, it works fine in my other sheet, however, I had to do slight adjustments to it in this sheet and it clearly populates the correct cells, however, it is not giving me the correct value, and instead just puts 0.00. Can some please help me figure out the…
-
Can you match between multi select dropdowns?
I'm trying to match values between two multi drop downs. In one sheet there are rows that are associated with multiple groups, in the summary sheet are the groups that are selected. Is there a way to write a formula that will look at the summary values in the dropdown and see if any of those values exist in the second…
-
Sheet Summary Formula Error
I am trying to create summary field on a sheet to show how many rows contain a users name. The summary formula is as follows: =COUNTIF(VP:VP, FIND("a user name", LOWER(@cell)) > 0) This works fine when the column VP contains actual values with text. However, if I put in a column formula to calculate their name from a…
-
Find function not working. Can you help?
I'm trying to count a particular name in a column but keep getting the #Unparseable error. =COUNTIFS({LR Date Created}, IFERROR(YEAR(@cell), 0) = 2020, {LR Date Created}, IFERROR(MONTH(@cell), 0) = Month@row, {Assigned To}, FIND(“Kamil”, @cell)>0) Can you help???
-
Sheet Summary formula not working
Any ideas as to why this formula isn't working? =COUNTIF([Return- boundaries between works areas]:[Return- boundaries between works areas], "Very Important") I coped the column name from the actual column as to not misspell anything etc. Then I tried typing it out thinking maybe the copy and paste went screwy. Nothing…
-
Returning a value based on multiple criteria
I am trying to autofill a summary table using formulas. I am able to autofill the monthly counts using date criteria, but I can't get the total numbers to autofill. I tried using the below formulas to pull from the two places where I have the counts for total members and total new members of each member type, but I keep…
-
Why is VLOOKUP returning wrong data???
Here is the formula =IFERROR(VLOOKUP([Primary Column]@row, {Foreman Pre Job Checklist Range 1}, 2, true), "Missing") Should be returning 10/26/2020 but its pulling 10/20/2020 instead. Also tried the formula with false but then it represents "Missing" as indicated in the formula Formula is in the bottom picture, referencing…
-
How to get a value based on a series of dates?
I am trying to return the the number of highest level training completed. There is eight columns in my sheet for training completion date: "level 1 completion, level 2 completion, level 3 completion" etc. I made a column called "Training Level" and was hoping to get it to reflect the highest level of training completed…
-
How to use nested IF formulas or conditional formatting with dates and date ranges?
I am trying to use either conditional formatting or a nested IF function to color code a row based on when it was last updated. I have two auto-numbered columns, Date Created and Date Modified. I would like for it to return green, either as a symbol with symbols column (IF function) or in the task bar (conditional…
