-
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…
-
% Complete based on Todays date, Start and End dates
I'm looking to return a % complete based on the start and end dates and the current date. So if a task starts on the 17/7 and ends on the 31/7, and today is the 24/7 - the % complete would be 53%. - (I want to have this as a separate column so I can keep dependencies on the actual % complete column) =(MIN(TODAY(),*finish…
-
How to make a calculation return blank
I have a simple IF() calc that I thought would return blank if false, but when I go to make a color rule on if this column is blank it doesn't work. If I copy the output of this calculation is appears to be returning whitespace, but I can't use [field] is equal to {put a space in the text box} in the color rule.…