-
Odd way to emulate excel formula counta()
Needed to count all cells for a project, found how to do it, and am posting it here in case it helps someone else. on range a =countifs(A:A,@cell = @cell)
-
Index - match
Hi All, I've been trying to get the Name A, and the minimum scoring is 3. =INDEX(C2:C11,MATCH(1,(A:A=B13)*MIN(C2:C11),0)) = 2 Anyone can help on the formula?
-
COUNTIFS Errors
I'm trying to create a Sheet Summary field formula that will count up the number of "Yes" (formula-generated, if that matters) cells in a column if the date, in another column on that row, falls within a given month/year range. This one seems to be working... I think: =IFERROR((COUNTIFS(OTD:OTD, OR(@cell = "Yes", @cell =…
-
Summary Status
Hi, I am trying to populate the overall status of a Project on to the Dashboard. So lets say, these are the 4 status types. How do I populate a rollup status in a secondary sheet with the help of formuale wherein, if any of the statuses are "Complete", "In Progress" Or Not Started", then it says On Track but if any of the…
-
#unparseable error when creating a symbol formula
Hi, I am trying to create a formula to return a status symbol based on the date on a cell. Basically, I have a column called "Date PRF Received" and I want to put a formula in the next column to show a Red light if the date is prior to today's date and Green if the day is still in the future. I am using the formula:…
-
I have been progressing well and solved many complex formulae but this simple one has me
I am trying to return the closest parent for the equipment ID when i have other interceding hierarchy levels between the true parent and the Equipment ID. I keep getting a syntax error and for the life of me cannot see it. =IF(Heirarchy@row = 5, INDEX(ANCESTORS(Heirarchy@row, 2), [Equipment ID]@row), IF(Heirarchy@row > 5,…
-
How can I count two drop down options in a single cell?
I was able to count single drop down options but I was unable to figure out how to add two drop down options, here is the formula I am using: =COUNTIF({WHS Hot Issue Tracker_NO Range 3}, HAS(@cell, "Schedule")) (This is to count only "Schedule" items on the Column. I have several rows with two options, here is one example"…
-
CC Myself on all Alerts
Is there a way to CC my team mailbox on all outbound alerts that result from a form submission?
-
Count Checks on Another Sheet
I need a formula that matches a user's name on the first sheet and goes to a second sheet to find that same user's name and counts how many times that user has a checkbox checked off. I tried something like this but am getting #NO MATCH as a result. =INDEX(({Target Sheet with Username Column Selected}), MATCH([Username…
-
Negative Values corrupting integrity of Symbol Display Formulas
I've got a sheet that is setup with a "Synergy Savings Risk" column with a formula to show the red/yellow/green status based on the "Synergy $ Performance %" which is a formula comparing "Synergy/Dis-Synergy Actual $" column with "Synergy/Dis-Synergy Target $". I have a problem in that when the "Synergy/Dis-Synergy Actual…