-
Broken cross-sheet formula
I have a cross-sheet formula that reads from nine separate sheets. It's a COUNTIFS formula that is designed to count the number of times a combination of options occurs across three columns - a select from a dropdown text column, a date column, and a checkbox column. If a user selects, say two of those options, but not allβ¦
-
Count & collect value where cell with multiple value options contains a specific value
Hi, I currently have a formula that is counting the total number of rows in another sheet that have a "Status" = "In Progress" and have a "Value Stream = "Platform & Shared Services". See attached screenshot - left side of screenshot. This formula worked just fine when in the other sheet, the "Value Stream" column was aβ¦
-
SS Formulas
Does any one know a formula to calculate MRC?
-
How to find newest date
Hi all, this is probably an old question asked again, but I am trying to find the newest of entries on a sheet and return the value to another sheet. Here are the details: - PrjectSheet contains the list of the projects; - NotesSheets contains multiple note entries per project; - None of the columns are intentionallyβ¦
-
Have Data Sheet and Report Sheet - Formula Counting 2 Reference Columns
I need to count the number of times 2025 is in column A and has a 2025 in column B and if they both have a 2025 count that. I keep getting an uparseable error. =COUNTIF({The Compliance Training Tracker Range 1}, >=DATE(2025, 1, 1), AND {The Compliance Training Tracker New Range 3}, <>"")
-
How to reference different sheets and columns based on Criteria?
I am having trouble referencing data between two sheets. What I am trying to do is in Sheet 1, if a cell in column A matches a cell in column A in Sheet 2, then return the value in column B of sheet 2 on the same row. or in other terms for my specific project: If program name in sheet 1 matches the program name in sheet 2,β¦
-
If / and forumula
Hi I'm trying to get a formula that returns the following grades. High Distinction (HD) 85-100 Distinction (D) 75-84 Credit (C) 65-74 Pass (P) 50-64 Fail (F) <50 I've tried this a few different ways but keep getting the #UNPARSEABLE message. Appreciate any help with trying to get this formula to work. =IF(AND(Percentage1 <β¦
-
What am I doing wrong?
Shows #Incorrect Argument set =IF(AND(IF([Jan Scheduling Location]@row = "BPHO|Belen Public Health Office", [Jan Appt Type]@row, "Err1"), IFERROR(INDEX(DISTINCT(COLLECT([BPHO|Belen Public Health Office AT]:[BPHO|Belen Public Health Office AT], [BPHO|Belen Public Health Office AT]:[BPHO|Belen Public Health Office AT],β¦
-
Different way to track health
I have a project without a set end date and am being monitored on if I am getting it closer to completion by the % complete field, how can I make a formula that tracks health based on that forward progression so that if my % complete goes up it stays green but if it stays the same for three days it goes to yellow and if itβ¦
-
Nested IF Statements to Determine Priority
Hi everyone, I've written nested IF statements for a Risk Register, looking at Probability and Impact to determine the color. It's been a while since I've done this and I'm obviously rusty. Can someone tell me why the following is unparseable? =IF(AND([Probability]@row = "Highβ, [Impact]@row = "Highβ), βRedβ,β¦
