-
Due date vs when NEW ETA is entered - Formula help
Good morning. I know I'm missing a closing bracket somewhere but I can't figure out where. What I'm trying to do is show 1 - 4 wks out and then anything further show 5+ Wks out BUT… I need it to look at the due date UNLESS a NEW ETA is entered, then I need it to look there. Here's the formula I have thus far IF(TODAY() >…
-
Countifs for cells containing a letter
Hello, I have a formula to count how many hours of work I have assigned to me in a given week. It has the following inputs: "Owner" and "1st day of week" and it looks in a different sheet for all rows that meet that criteria and returns the estimated hours for the tasks. My formula is below and I want a solution for the…
-
Help with an Index Match Formula - If Error Required?
Hello! Currently using the below formula to pull data from one sheet to another. =INDEX({Survey Home Name}, MATCH(Home@row , {Optician Ear & Dental Care Company Survey Range 1}, 0)) I'm getting a #NO MATCH error for any data not yet on the first sheet, but I would preferably like this to return as 'no'. I wasn't sure if I…
-
Subject: Help with INDEX/MATCH Formula – Pulling Data from Sheet A to Sheet B
Hello, I’m having trouble with an INDEX/MATCH formula that's intended to pull data from Sheet A (Zoho) into Sheet B (Hub) based on matching email addresses. Here's the formula I’m currently using in Sheet B: excelCopyEdit=INDEX({Zoho Report Range 2}, MATCH([PERSONAL EMAIL]@row , {Zoho Report Range 3}, 0)) However, the…
-
Calculate Days Open?
Hi everyone, I am struggling with figuring out what formula to use to calculate days open between two date columns on a Sheet. Column 4 = Submitted At Column 5 = Closed Date Column 6 = Days Open No matter what formula I try to use (NetworkDay/NetworkDays/Sub/Days, etc), I get the #invalid Data Type error. Any ideas why?…
-
duplicate entry checking 2 sheets
I have an invoice intake that pulls into an 'In Process Invoices' sheet. Once the invoice gets to a certain approval point it moves to another sheet 'Completed invoices' I need to ensure that there is a notification/color change/something that notes that an invoice number is a duplicate. i.e. once the new invoice is…
-
Formula to pull latest updates from a row
I am trying to setup a dashboard that gets updated with KPI's monthly. But, I only want the most recent entry to be reflected in the charts/dashboard. I get the gist of how to do it with if/or/isblank formulas, but can't quite get it right. It's reversed right now, I can fix that. Am I on the right track here, just need to…
-
How to use a nested if with count
We would like to have all the criteria for a created date by week. the number of new helpdesk tickets created by each end user for a given week. Example: Week of 7/7/25 Mickey submitted 5 tickets, Donald Duck submitted 10 tickets, part of Donalds 10 tickets only 5 were reported in week 7/7/25. Report Week of 7/7: Name:…
-
Rank Formula Multiple Results
I have previously received help with Ranking formula where there is more than 1 result it needs to rank the most recent week, which was resolved and worked fine - until last week. The new issue is that I have the rank 3 & 4 is being excluded When reviewing the data I think this is the issue, just not sure how to adjust the…
-
Using If And with symbols
Hello, I'm currently trying to write a formula and am running into issues. I've added a "Project Health" column with red, yellow and green symbols. I would like these to change automatically using the following cells to determine. If "Arrival Date" is blank, and "Customer Requested Delivery Date" is within 2 weeks, red If…