-
COUNTIFS not Counting
i am having trouble getting a COUNTIFS formula to work. what i want it to do is count Sleeve ID based off of Sleeve Length. For example I want it to tell me there are 20 6"ø Sleeves that are 8" Length. For some reason it is not counting I have attached a screenshot with the formula in it. for ease, here is the formula…
-
Countif
Hello all! I am trying to use COUNTIF to count all the cells in the column that say a certain product name. Is this possible if I am trying to count something other than numbers? In the screenshot I attached, I want to count all the "B2Q-B1ETT2 - B2Q Tester" in the "Items Shipped" column.
-
Formula to Outdent a row, when a certain status is reached
Hi all, I've been using Smartsheet for a while now, love it, but I'm a bit rubbish with formulas. I'm trying to have tasks 'de-parent' from its parent task (Outdent to '0') when a certain status is set. I got to this formula (to no avail, but to help illustrate what I'm on about): =IF(Status143:Status159)="COMPLETE…
-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
help with average formula
Hi, I am having trouble with getting an average of a column. its a formula based column and since some rows dont meet all the criteria, some rows state INDEX DATA. How do I find the average of the numbers in the column using a formula?
-
CountIFs and Date range formula
Hi, need help with a formula. I am trying to count a type from one column 'Finding Rating' against a date range in another column 'Last Completed'. So far I have tried the following but they have all come up with UNPARSEABLE. FYI Conformance is one of the types that I need to count =COUNTIFS({Finding Rating}, =Conformance,…
-
Count multiple blank columns
Hello, I have a task board with multiple columns like Original Due Date, Current Due Date, Goal, and Status. I am trying to come up with a formula that "audits" the data for blanks so we can easily see that Person A has 5 tasks that have blank columns they need to fill out. In the formula below [Column7]$20 is the person's…
-
Count children rows by status
Hi - I have a sheet with parent rows and children rows. Each child row is associated with a status (Not Started, In Progress, and Complete). For each parent row, I'd like to count the number of child rows that are in each status. I need to present this information in a dashboard . Ideally I would create a separate summary…
-
Looking for a formula for checked boxes xx/xx checked
I am working on a tracking type of sheet. I have 4 columns that i have inserted check marks for: D2:D301 I2:I301 N2:301 S2:S177 The check marks are great, but i would like to take this one step further and have a tracker up at the top that as an example says xx/1072 to signify how many boxes are checked out of how many…
-
SUMIF Formula - Incorrect Result?
Hello, I was looking over the SUMIF function yesterday on this page and noticed the incorrect result for the first row example. Am i wrong or should the correct result be $2303.00? FormulaDescriptionResult =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3)Revenue Gained. SUM…