-
Dynamic Cell linking empty fields
I'm trying to use cell linking but it won't let me link a cell that doesn't have data in it yet. My plan is to have it link to a cell that will have data put in it gathered from a form. The end result is that I'll have two sheets. The first sheet is populated with data gathered from the form, and then the second sheet will…
-
Which formula should I use if I want to add up all values from a column?
To give a little bit of context, I am creating a report where I can count whether a cell has been filled with information. The column I am using is a drop down list with 5 values. Let's say these values are apples, bananas, oranges, pears, etc. I am not looking for the total of each specific value, I want all of the values…
-
SUMIFS formula returning #INCORRECT ARGUMENT SET: order of Range & Criteria?
Hello, I cannot figure out why this SUMIFS is not working. When I break up the SUMIF criteria, they both work fine. But when I put them together, I get #INCORRECT ARGUMENT SET error message. =SUMIFS({MH Client Profiles v2 Range 13}, "East", {MH Client Profiles v2 Range 16}, 1, {MH Client Profiles v2 Range 3}) All I want is…
-
Can Conditional Formatting trigger specific formulas?
The spreadsheet in question is a shipping/inventory database. The top rows where Device SKUs are listed are the total contracted amount of devices a client pays for. Then as we create shipments (which go under the blue parent rows), we've included a SUMIF formula that, when the Device SKU is entered in the shipment…
-
Does the COUNTIF Function work if the criterion have decimal places?
I am working on an extended process and I want to sub-categorize a set of steps. Ideally I want to use the 1.1, 1.2, 1.1.1 as step headers but when I try and do functions to count cells it is not working. Example: The COUNTIF functions work for the whole numbered entries but will not pull with the decimal entries. Here are…
-
How can I compare two cells in a cross sheet reference?
Hello, I have a COUNTIFS formula (below) that returns the number of items that pass all the tests. Basically, count an item if it's unique id is not blank, it's % complete is 100, and the risk area is Antiboycott. This formula works beautifully. =COUNTIFS({ExportUniqueID}, NOT(ISBLANK(@cell)), {ExpComp}, @cell = 1,…
-
Averageif without maximum payment
Hallo, I want to calculate the average damage without considering the maximum damage. I tried this: =AVERAGEIF(Zahlung4:Zahlung140; >1) - MAX(Zahlung4:Zahlung140) but it doesn´t work. I get a - value Any idea ? 🙄
-
Is it possible to trigger an alert notification ONLY if the value of a field increases?
I have a formula that counts absences for the past 6 months. A formula in another column looks at the first and when that number reaches 3, it adds an occurrence (value changes from 0 to 1). I've set up automation to notify the supervisor that the team member needs a counseling. Since my only option for automated…
-
Different types of zeros?
The formula below is creating multiple "zeros". See pictures. What am I missing? =IF(Balance@row = "ERROR", "ERROR", IF(Balance@row = "TBD", "TBD", IF(Balance@row = "DEDUCT", "DEDUCT", ((SUM(Jan@row:Dec@row) + SUM(CHILDREN(Jan@row:Dec@row))) - (((SUM(CHILDREN([Contract Amount]@row), "Change") + ([Contract Amount]@row)) -…
-
IF(OR with RYGG
I would like to automate a RYGG column, assuming that my team is entering there own start and finish dates but due dates will be created by senior staff. Yellow=In progress Red=Overdue Grey = Not started Green=Completed So IF start date is before due date, Yellow or if Finish date is before due date Green, etc. An…