-
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…
-
Schedule Variance
How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.
-
Count Compliant Status Reporting
Hello Community, I am pretty stumped on this one; I want to count the number of rows (projects) that are in and out of compliance for their status reporting ("Status Date") based on their project stage ("Project Stage") as different items in the Sheet Summary. Currently, "Project Stage" has multiple possible stages, but…
