-
I want to count dates in the colum "Solldatum" that are smaller than today.
I tried it with countif and it worked in Excel in German with the following formula: =ZÄHLENWENN(A2:A13;"<"&HEUTE()) as Example. What do I have to do in smarthsheet to get back the number of valid dates (in this example above the value "2")
-
Counting physical inventory while removing duplication...
I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is, some of these Unit Numbers have multiple work orders which are listed on another…
-
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…
