-
Formula to Sum values in One Column of a multi-column range
Is there a formula (or trick) to use to do the following?
-
COUNTIFS Formula: Not getting the desired result
Hi there My COUNTIFS formula is not calculating what I want, correctly. We have x5 items that are past their delivery date. x3 Of the items are in the "Incomplete" stage, x1 item is in the "Ready for Collection" stage and x1 item is still in process. I want to count the number of items in process past their delivery date,…
-
Combining "blank" cells with a checkbox - notification
I am trying collectively check the box for "MIssing coating Weights" IF - one column of each coating weight is blank AND the Recheck and/or No Coating Weights Required box is NOT checked. Thanks! =IF([Recheck and/or No Coating Weights Required]@row, 1), "", IF(AND([1421 CTG WTS OP]@row = "", [902 CTG WTS OP]@row = "",…
-
Formula Help Needed: To populate unlimited level of children row with Parent data
With reference to the following screenshot, we want to Populate the EP Number for all children under Level 1, regardless of the number of hierarchy with the EP No at Level 1. At this moment, with =IF(COUNT(CHILDREN()) > 0, [EP No]@row, PARENT([EP No]@row)), row 4 onwards are empty. What formula can I use to populate the EP…
-
Index Collect First Value from A Column
Hi All, Having trouble with index collect, I have a formula in a cell that I've added +"" to make it a text (Sprint Planning) and under Planning Header am trying to have a formula that essentially states: If the sprint value column is not empty, then return the first text value =IF([Sprint Planning…
-
Can we write formulas based on the Default columns (attachments, comments, row action indicator)?
I want to add some checkbox columns based on the row action indicator column (which is a system/default column) - if there's still a pending update request, the [updated?] column is unchecked. Even better, can we filter based on the default columns?
-
Have a formula that numbers rows and want it to only count certain rows
Hello, I want to sort items by priority based on order of the rows in the Smartsheet. So, I want lower numbers (rows towards the top) to be shown as a higher prority. I am using the formula: =MATCH([Task Name]@row, [Task Name]:[Task Name], 0) However, I also want to only include certain rows. In particular, I want to only…
-
If/then formula issue
We are using a form to perform inspections. If any inspection enters contain a "no" to any question it automatically becomes a "fail" for that inspection. I am trying to build a formula that will calculate a "Fail" if any of the entries in the row are "No". I have tried everything I can find and I am struggling to find a…
-
Utilizing the "COUNTIFS" and "HAS" for a dropdown list column
I have been trying to use the "HAS" formula with a dropdown list column associated with another sheet using "COUNTIFS": =COUNTIFS({Week Number}, =WEEKNUMBER(TODAY()), HAS({Actions Remaining}, =[Primary Column]@row)) I am currently receiving #INCORRECT ARGUMENT SET. I have a column listed in another sheet as "Actions…
-
SUMIFS with 2 criteria coming up zero
Hi! This formula keeps returning a zero. I am trying to get it to count two different things in the same column (not sure why they were labeled differently) but when I get the formula plugged in it comes back with zero, when I know that's wrong. I want it to count up the engineering hours based on the product lead,…