-
Count dates and return a valve from another sheet
I need to reefer to another sheet and count any row that has a "Fill Superintendent" and return a number if it is =< today in column. Then a valve if its => 60 days Thank you for any help
-
CONTAINS, MATCH, INDEX Help
I'm trying to use CONTAINS, MATCH, and INDEX in cross-sheet formulas to pull location-specific system component inspection information from invoices to my asset register. Sometimes, the invoices will have more than one system component on them. I want to make sure the formulas will pull the information for each of the…
-
Function Help
Hello, I have a sheet set up with a form to track historical data for collections efforts daily. On the Summary tab I'd like it to be able to display today's stats. I'm not sure what function to use to make this happen. How it is set up is column "A" is the date and column "B" is a percentage. I would like the summary to…
-
Allow a cell to only be certain days of the month
I put together schedules that include public hearing dates that are typically certain days of the month , i.e. 2nd Tuesday, is there a way to assign this to a cell in my schedule? Currently I have to go to that point in my schedule and manually find the date and each time the schedule changes I have to make sure I update…
-
If Blank, Today's Date Formula
Hello, I'm having trouble finalizing IF statement for the following: If "Approved By" is NOT blank, the Date Approved = Today's Date Thank you for the community support in advance.
-
COUNTIFS not Counting
i am having trouble getting a COUNTIFS formula to work. what i want it to do is count Sleeve ID based off of Sleeve Length. For example I want it to tell me there are 20 6"ø Sleeves that are 8" Length. For some reason it is not counting I have attached a screenshot with the formula in it. for ease, here is the formula…
-
Struggling with INDEX and MATCH
Hello, I am trying to automate task assignment using the INDEX and MATCH functions. My formula is as: =INDEX({Order Sets Team Contact Roster Assigned To}, MATCH(Role@row, {Order Sets Team Contact Roster Role}, 0)) It seems to work for one role but produces a no match error for the rest of the roles. Please see attached…
-
Count multiple blank columns
Hello, I have a task board with multiple columns like Original Due Date, Current Due Date, Goal, and Status. I am trying to come up with a formula that "audits" the data for blanks so we can easily see that Person A has 5 tasks that have blank columns they need to fill out. In the formula below [Column7]$20 is the person's…
-
Countif
Hello all! I am trying to use COUNTIF to count all the cells in the column that say a certain product name. Is this possible if I am trying to count something other than numbers? In the screenshot I attached, I want to count all the "B2Q-B1ETT2 - B2Q Tester" in the "Items Shipped" column.
-
SUMIF Formula - Incorrect Result?
Hello, I was looking over the SUMIF function yesterday on this page and noticed the incorrect result for the first row example. Am i wrong or should the correct result be $2303.00? FormulaDescriptionResult =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3)Revenue Gained. SUM…