-
Need help with COUNTIFS, CONTAINS, AND
I am stumped and cannot find an example. I want to count the cell in range 1 contains the word "flight" and the cell in range 4 on the same row contains the word "enterprise" This gives #incorrect argument: =COUNTIF({2022 Project List Range 1}, CONTAINS("flight", @cell), AND({2022 Project List Range 4},โฆ
-
Divide By Zero Error
Hello, I was attempting to rid my sheet of the #DIVIDE BY ZERO ERROR and now I am getting the #INCORRECT ARGUMENT returned. What am I missing? #DIVIDE BY ZERO ERRO Formula =(AVG(COLLECT([PO Total]:[PO Total], [Order Date]:[Order Date], >=DATE(2021, 12, 1), [Order Date]:[Order Date], <=DATE(2022, 12, 31)))) #INCORRECTโฆ
-
RYG function based on Status and Start Date
I am able to have the Status (RYG) show up based on Status (which is tied to percent completed). I am trying to add the function so if the Start Date is in the future the status defaults to Green. This is what I'm using for the RYG now: =IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Red",โฆ
-
IF AND Formulas for Flagging
Hi again, I am trying to have flag a parent row based on 2 separate criteria: 1) if the overall risk score is <50% and 2) if any Children rows have any High Risk questions Flagged I have tried it a couple of ways still receiving #IncorrectArgument and #Unparseable Below is #IncorrectArgument For #Unparseable: =IF([Riskโฆ
-
IF(AND) Formula
Hello, I am trying to write a formula to look at a due date field and compare it to a status field. If the due date is less than or equal to 90 days from today, the status symbol is green. If the due date is less than or equal to 60 days from today and the status is open, the status symbol is yellow. If the due date isโฆ
-
Countifs suddenly returning #NO MATCH
Hello, This morning my dashboard looked normal. A few minutes ago some metric widgets now display #NO MATCH and my charts say "Unable to display chart We're unable to read the source data. Please ask the Admin to select a different data range for this chart." I am the main Admin and I haven't made any changes today. Anyโฆ
-
need help with a formula
so i have sheet 1 with rows 1.Priority 2.Tag Name 3.Blank sheet 2 with rows 1.Blank 2.Cable name 3(would like the Row 1 from sheet 1 and change when I change it in sheet 1) I would like a to make a formula to say IF sheet2 Cable name Matches Sheet 1 Tag name. then show Sheet 1 row 1(Priority) on Sheet 2 row 3.
-
Using COUNTIFS with OR and CONTAINS
Hi All, I'm trying to create a formula to count how many requests of a specific type my team handled on a given week. I have the table set up like this: in the column of insights decks, I would like the formula to count how many times a request was put in that week, that has either Insights, Screenshots, or Campaign in theโฆ
-
Monthly Automation report sends out last months data
I have a simple automation that looks at an employee sheet. On the 1st day of each month at 10am Central a report is sent to my email that SHOULD show the current months work anniversaries. However, every month I receive the email on the first of the month and it shows the PRIOR month anniversaries. Within the sheet I amโฆ
-
Formula for Changing Symbols
I am trying to create a formula where the symbols (red, yellow and green circles) change when red when it is passed the Extension Deadline date, yellow when it is 60 days from the date, and green when it is more than 60 days from the date. What is a formula I can use to achieve this? As of right now this is the formula Iโฆ