-
Nested IF error
Can someone tell me where to place the last [value false] information on this very long formula? I'm having issues with it always showing the last true value (20) for the false values (School Missing) or an error message when I move it to a different spot on the ending parends: =IF([Grading Scale]@row = "50", 2,…
-
Sum Of Children (but don't add any negative value fields)
All, I'm going nuts. I can't seem to figure out a simple formula that is essentially "sum of children, but don't factor in any children with negative values". Can someone please help? Many thanks, Evan
-
How to automatically copy a cell value to the next column
Hi =), It is likely a very easy solution for you guys. I've two columns one for the client names (Dropdown list) and another one for OTHER ( if they can't find the client name from the dropdown). I wanted to bring the OTHER client name automatically to the client name once someone enters data in the OTHER column. Goal is…
-
Trying to match values from different sheets
So I have the master sheet that has a Machine Name column, and I'd like to match it to a Department that is inputted in a separate sheet. Sheet 1 has 2 columns, Machine Name and Department (this is where the formula will go). Machine name is constantly added with random names being chosen out of a drop down selection from…
-
Index/Match works on all rows except a couple
Hello, I have a strange issue where my INDEX/MATCH formula seems to work on all rows except, for example, this one below. This is a listing of requests for a client. I've hidden certain columns for privacy, but the hidden columns are not used at all in the formula. Every request has a unique ID (primary column). There are…
-
COUNTIFS for whole Sheet
Hey, This is probably an easy fix but I am having no luck. I want to count if anywhere on a sheet has a "4" in a cell. I also want this to separate the counts by "ITCMW", "ITCT" & "METC" My current formula is: =COUNTIFS([Pre Trip Completed]:[Doors/Gates], HAS(@cell, "4")) I need to include System:System, "ITCMW" in this…
-
Formula - Cross Sheet Referencing
Hi Community, I’m trying to cross-sheet reference. After I type the start of the formula, the box to “Reference Another Sheet” appears. I clicked it, found my sheet, chose the column, but the “Insert Reference” box remains grey. I’m the owner of both sheets. What am I missing? Screenshots attached. Thank you!
-
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…
-
Status Indicator formulas
I have been working on this for two days and I finally decided to ask for help. I am trying to achieve the following: If Dev Progress is marked as "complete" then "Blue" If Dev Progress is marked as "In progress" and Today is between Start date and End date then "Green" If Dev Progress is marked as "not started" and Today…
-
Formula in a dropdown menu
This is what I am trying to do... I need the total of "amount Due" if "invoice" is selected. And the Total of "Amount Due" if "On Order" is selected. I would like for that info to populate at the top Help!