-
Trying to include two bits of criteria from the same column in a COUNTIFS formula
I have used a variation of this formula so I can compile the total amount of stores in two particular states. I was able to exclude both NY & MA in a similar formula using the <> before {ALL STORE Rollout Schedule-IT-1547-EG Range 5}, but now that I ONLY want to include MA & NY I'm having trouble. I'm able to do one state…
-
How do I count multiple types in a column?
This is my current formula that works: =COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {QUARTER}, HAS(@cell, "Q1'23")) But now, I need the formula to count multiple quarters (see the last part of the equation). I need it to pull Q1'23, Q2'23, Q3'23, Q4'23. How do I add those on? ... Thank…
-
What's the purpose of ISBLANK or NOT(ISBLANK
Pretty simple and quick question. Why would I use an ISBLANK formula, instead of just adding ="" in a logical expression? Or why would I use NOT(ISBLANK instead of <>"" in a logical expression? Maybe because it's easier to interpret if ISBLANK or NOT(ISBLANK is used?
-
Sum column if another column is not blank
Hello all, I am trying to create a formula that will only sum budget cells that have a date in another column, if the date column is blank then those budgets would be excluded from the total sum. I'm having a hard time finding any formula that will work, possibly because these cells are linked from another sheet? Any help…
-
Why does my Metrics constantly stop calculating correctly?
I've been making a "Metrics" sheet for some time now, and in the beginning everything was calculating fine. But it seems to be when I add more "data tables" if you will, or more metrics, some tables stop calculating correctly. Here is what my sheet looks like for a better understanding So, the first few-ish sections will…
-
IFERROR LOOK UP
Hi All For our timesheets we use IFERROR to check another sheet against a job number, I now need this to check over multiple sheets not just 1 how can I do this please? The current formula is below. =IFERROR(INDEX(COLLECT({PMYS Job Tracker - Boat}, {PMYS Job Tracker - WIP}, WIP@row, {PMYS Job Tracker - Line}, Line@row),…
-
Calculate amount of days untill deadline and how many days is overdue
Hi Hoping you guys can help! I'm trying to calculate the days between a desired deadline and today (so kind of a countdown) and in the same field then also count if the task is overdue and by how many days. so, I was thinking, if it was counting down the days, it would be a positive number and when/if a task is overdue the…
-
Rolling 12 month - need to mark line items in a sheet if they fall in the last 12 months
I have a detail sheet where we gather data as projects are closed. We want to be able to have reports and dashboards for the current year as well as the last 12 months. I have current year figured out without any issues, but I am struggling with how to filter for a Rolling 12 month period. I have created a Metrics Sheet to…
-
Formula to count the overdue task with Assigned Person
To brief, need a formula to know the overdue count for each assigned persons. With these details, will help show a chart in dashboard
-
Formula
I'm hoping someone can help me out here. I'm looking for a formula to calculate how many items have been sold but have not been shipped. Example: I want it to add the #s in the Color column of all lines where WH Location = 8A-8Z unless "Shipped" is in the Vendor column.
