-
Behavior of "=" Operator
On several occasions I have confused myself, not understand why I am getting a #NO MATCH error when comparing a Text/Number column to a Auto-Number column, and I have realized why... Results in False 001 = 001 099 = 099 Results in True 100 = 100 10000 = 10000 I understand why this is happening, but I do not necessarily…
-
Combine values in column only if value in each row is less than a value
I have a column with an identifier in each row and in another column I have a value in each row. I want to search the second row for any values that are less than a reference cell, and if less that that reference cell, I want the text from the first column to be displayed in the cell the formula is in separated by , if…
-
Show next pending task in Summary
Hello, I am trying to show the next pending (open) task in Summary, so it will show on my Summary report as well. In the summary report I also want to show the delivery date for that task. Basically if the previous task is Completed (checked), then I want the next one to show in Summary. I am trying an IF and VLOOKUP…
-
Change parent symbol based on children symbols
I'm seeking a formula that will allow the parent symbol to change based on the children symbol. So, if there is a red in any of the children rows, the parent row will show a Red. If there are only yellows, then parent will so yellow, if all green, parent green. Thank you!
-
I need formula Help!
I am trying to find a formula that will allow me to Reference another sheet and look in two columns (One is a multi select drop down, and one is a text column) and find the row that contains both of those values and return a third column (Contact) from the referenced sheet. So Sheet A is where I want the formula to return…
-
Formula help
I am trying to create a count or tally formula. When two criteria are met then I consider that full contact. Criteria: When the date of contact is filled out and the comments from that contact are filled out. I want to do this over and over again about 40 odd times. So if date #1 is filled out and comment # 1 is filled out…
-
SUM within a date range
Hi, I have 2 columns, 1 is a purchase amount, and the second is a purchase date. I'm looking to create a table from this that breaks down total amount purchased by quarter. I've tried the following among a few other variations with no luck: Q1: SUMIFS([Purchase]1:[Purchase]34, [Purchase Date]1:[Purchase Date]34,…
-
Index/Match/Match
I have two sheets that we are using for evaluations. The first is for a high level score and the other is for specific situations. The high level one will be filled out once per application and the specific situations will be evaluated separately per application. With this I would like to pull the high level scores into…
-
Count of Days Worked
What I need is a monthly count of what days were worked during the month (Based off form submissions) regardless of quantity. For example, if our Customer Repair/Renewal Workshop gets 10 submissions on December 1st and 15 submissions on December 6th, all I need to have the formula count is the 2 days worked during that…
-
Tracking a sum from separate column of specific values
Hello, First, I want to thank all of you for your help on this community. I'm learning a lot and this place has helped me out immensely. I've looked around and have found some similar questions, but I can't seem to get this to work, so I want to turn it over to y'all. So let me start with a snapshot of my sheet. What I…