-
SUMIFS/COUNTIFS Date Issue
Hi all, I am attempting to create a formula to add up all the Employees from a sheet from last month. This sheet is pulling in totals on an automation monthly. The formula works except the Month section keeps making it 0 when I see it should be a 1. I have a similar issue with a COUNTIF formula. Can someone tell me the…
-
Making an order request form but need the ability for multiple items entered into the same order
I work at a manufacturing company, and I am creating a request form for our parts department. The way it is intended to work, is our Maintenance Technicians fill out a form with basic information (their name, part number, priority level etc.). This form notifies the parts department to check into the order and then sends…
-
Countifs formula for tickets created within a month
Hello, I have a situation where I am trying to count tickets that were closed within the same month they were opened. I have a status column, a created date (automated from the system) and a completion date. I am using the formula below but the system is giving me a value that I know it is not right. I am thinking I need…
-
SUM not totaling negative numbers correctly
I need to use a formula to get the totals for 4 cells that contain formulas. I have used the SUM or AVG function on this sheet for the same purpose and it has worked fine. Now it's not working and I'm wondering if it's because I'm trying to add negative numbers. Anyone know how to correct the total cell formula so it…
-
Manual Override of Formula Index/Match for Out of Office with Column Formula
Hi All, I have an index/match pulling in data relevant to a Business Unit from off sheet. I need to get it so that I can override this formula data to be blank/allow entering of a different email address by the sheet user. What I have setup already (working with Column formula): 1) User inputs Business Unit (BU) 2) BU auto…
-
Need help with AVG(Collect - multiple criteria same column
I'm trying to use Avg(Collect to get the average number of days from another sheet. My problem is I need to search one column for 2 key words. Is Avg(Collect similar to Countifs( where you can't do this? The below formulas work (XXX is a holder) separately but I'm at a loss for how to combine them to yield the correct…
-
How can I create a NETWORKDAYS formula that results in a blank field until an End Date is specified?
I need a column to show =NETWORKDAYS(([Start Date]@row), ([End Date]@row)), but currently the rows where End Date is blank are returning #INVALID DATA TYPE in my formula field. I would like it remain blank until an End Date value is entered. =IF(NOT(ISBLANK([End Date]@row)), "Not Blank", "") returns the expected result.…
-
What is WORKDAY formula with SLA built in
Hello, I'm seeking a way to add in a formula that runs left to right. When a start date is added to kick off a set of activities, the cells on that line calculate +2 days (what I'm calling SLA date/ service level agreement date) AND also makes the date a WORKDAY (no weekends or holidays). Thank you so much
-
Help with formula that wont run
Hello everyone! This simple formula is driving me nuts =SUMIF([Is this before today?]@row, "Yes", ([Actual]@row-[Actual Cumul]1), "",) This keeps returning an #UNPARSEABLE error I'm trying to get an answer for simple sum If the current column (is this before today) is yes. Then subtract the "actual" value from the previous…
-
using a date value in a text column changes sometimes from German to US format
Hi all, I have a date column and I am using the locale for germany. The date column shows e.g.: 09.08.22 I use this in a text column like: ="some text " + date@row@rowanelizabeth The result is sometimes "some text 09.08.22" and sometimes "some text 08/09/22" What should I do, that always the german date format is used in…