-
How to use COUNTIFS with two criteria? One is a date range.
Hello All, I am working on gathers metrics for my team and need help figuring out how to use COUNTIFS with the following criteria: Check box is marked as complete The date is between 01/01/20 and 12/31/20 This will be an annual request, so the date will change year over year, but want to determine what my root formula will…
-
Formulas working for some columns but not others after update
Good Morning, It seems after the update I've been having issues with a formula on my project intake sheet/meta data sheet. I'm getting a #No Match error. Certain columns are connecting appropriately but others no longer are and I can't seem to identify why? See formula below Below is the intake sheet being referenced with…
-
'=date' Formula NOT Working
Hi everyone, I tried using the =date formula on a bigger formula and I have been running into the same problem and would like some help. I first tried =date(year(1@row),month(1@row),day(1@row)) and I got #INVALID COLUMN VALUE (column type of 1@row is date). It works on excel so I tried =date(2022,12,12) and I still got…
-
IF/OR/CONTAINS
Hello! I need some help with a formula that is currently yielding #INCORRECT ARGUMENT SET. The current formula in B2 is to check the box if the Sprint column contains Flux Staging Area, STAGING AREA, STAR BLAZERS INTAKE, Bulk Status or Parking Lot. What I have entered now is =IF(OR(CONTAINS("Flux Staging Area", Sprint@row,…
-
Nested If formula for RYG
Good morning, I'm having an issue with the following formula. The red and green come out, but the yellow comes back blank. Any assistance would be appreciated. =IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row <= 0.07 - 1, "Yellow", IF([% Complete]@row = 1, "Green")))
-
Any way to have a formula automatically change input when a set of new rows added?
Hi, trying to automate a process whereby the change from week to week on a project is reflected in a graphic on a dashboard. Right now, I have the source sheet for the data copy the rows to a separate sheet once a week. I want a formula to simply find the difference between last update and the new one. This is what will be…
-
How to separate multi select values and collect distinct values?
Each period (P1,P2,P3 etc) we collect KPIs for our projects. In some new KPIs we have been asked to collect the answers involve multi select drop downs. What we would like to be able to do is to each period have a list of only the unique values. I have tried using a formula which uses JOIN, DISTINCT and COLLECT and it…
-
I cannot get my IF statement to automate Harvey Balls.
Hello. I have used RYG balls before to show statuses for dates. But I am wanting to use them based on the value of a single cell. I have tried various formulas but they are not working. Would anyone have advice on this? I have included a screenshot with the formula.
-
Nested "IF" Formula Help
Hi all, I feel like I'm close but continue to get #UNPARSEABLE or #SYNTAX errors. The Formula: =IF(OR([Project Status]66 = "Training", [Project Status]66 = "Doc Control Released"), "Released", "Development"), IF([Project Status]66 = "Not Started", "Not Started", "") The Project Status column is a single select drop down…
-
How can you capture the date stamp of a status change?
I am trying to capture the date stamp for when a row changes from one status to another. Is there any workaround to get this information, for example from using an integration to another software or through a report? I know you can look at an individual cell's history, but I will need to do this for hundreds of rows, so…