-
VLOOKUP Issue
I am using a simple VLOOKUP formula. It is working for the first two rows but not after that. It is returning random numbers or "NO MATCH". Why am I experiencing this issue? Here is my formula =VLOOKUP([MD Name]@row, {MD Prior Month Prod}, 8
-
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…
-
Formula to calculate the days in between dates.
Hello I have a formula that will work with November dates or a November and December date but not with both December dates in the End bill date and Start bill date. =(([End Bill Date]@row - [Start Bill Date]@row) + 1) / (DAY(DATE(YEAR([End Bill Date]@row), MONTH([End Bill Date]@row) + 1, 1) - 1)) I have formatted the Start…
-
COUNTIF(CHILDREN() with AND for multiple condition check
Hi Folks I'm brain fogged as I've been putting together a nest of IFs to perform status roll up values to a parent off the values of the children and am hoping someone has a thought. I'm spinning on one bit that checks if the count of Late status is less then 0 AND count of Delayed is greater than 0. If true, then it…
-
% 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…
-
Index/Match is almost completely broken
Hi guys, I don't really know what's happening, and it's honestly the first time that it's happening to me. I have used this specific INDEX/MATCH syntax without issue, up until today. =IFERROR(INDEX({Office Time Zone}, MATCH([Office Number]@row, {Office Number Ref Sheet}, 0)), "") It's doing what I told it to, which is…
-
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.…
-
Good day, I am using the formula below but getting unparseable error.
=COUNTIFS(Year:Year, = YEAR(TODAY()), [Month Issued]:[Month Issued], = MONTH(TODAY()),([Due Date Forecast]:[Due Date Forecast], >0)))
-
Using Date Function & Referencing Other Cells
Hello, I'm trying to create a date using the Date function so I can use it in a formula. Is there a way to use the Date function using cell references instead of numerals? The syntax I'm trying (and failing) to use is something like =Date(Year@row, Month@row, 1). Thanks!