-
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…
-
How can I use two different inputs to determine a specific result in one cell?
Hi there - I'm not sure what is the best formula to use & appreciate any help! I have a 9 different scenarios that can return 4 different results. This is something like a matrix translated into the possible combinations. The matrix / combinations are in a separate sheet but can also be built into the formula directly, if…
-
Formula to count child rows that have not expired
Hi all, I have a sheet that contains parent and child rows. Each child row has an expiration date and I want to count the number of child rows that have not expired based on the expiration date in that row. Can you assist? Thanks!
