-
COUNTIF on FLAGS at PARENTS level not returning any value (number)
Hi Smart Community, I am trying to Sum my CHILDREN() Countif but it is not giving any value. All my sub-children is indicated as flag (1 or 0) Example When there is a delay release in a category Bug Fix : it will flagged out RED. On Bug Fix, I did =COUNTIF(CHILDREN()),1)+"" This seems to work fine and return with 2 (which…
-
Sumifs with range
Hi, Refer to below, trying to get total sum of certain items. Scenario : Sum numbers from the column, Color, if the column, Fruit is "Apple". I tried below, but returning error. Please help. =SUMIFS([color]99:[color]104), fruit99:fruit104, "Apple")
-
Circular Reference
Smartsheet Community How do I SUM this formula with in the Same Row without Receiving a Blocked or Circular Reference? Row17: IFERROR(Passed17 / $[Total Test Cases]$17, 0) Row 18:Is a Sum within the same Column as Row 17 =SUM(Passed18:Deferred18) Thanks
-
Updating a Date Column after another cell is updated.
I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected. For example: I have a single selection column with several options: Estimating Complete, Quote Sent, and Sale. I…
-
Use Wildcards in an INDEX MATCH formula
Hi everyone, I need to use INDEX MATCH formula to get a DS# with a CNDT# in another report. The easy formula would be: =INDEX({DS Report Range 2}, MATCH([CNDT Number]1, {DS Report Range 3}, 0)), "") but the thing is that sometimes there are more than one CNDT#'s in a single cell. Since INDEX MATCH looks for the exact match…
-
RYGB Symbols Average Formula
I currently having issues with creating formula that gets the average of 4 cells that have the option of 4 different symbols (Red,Yellow,Green,Blue). The goal is to show the average of the four cell symbol's in one here is what I have so far. =IF(COUNTIF([PW Goal]3, [BB Goal]3, [JQ Goal]3, [MC Goal]3, "Red")) = 4, "Red",…
-
Survey Form(S)
I'm currently working on Survey Form. I have made one for one "X" department. I need to make another survey for for "Y" department. The two departments have different heading but the two have same questionnaire but different employee names. How do I clone the first form into the second. And is it possible to the results…
-
Match and Index functions to create a table referencing another sheet
Hello, I need help creating a formula which will work. Sheet 1 - contains my data Sheet 2 - Contains the tracking matrix I am trying to create I need a formula which will look at sheet 1, determine if an inspection has taken place within a certain month, and then return the date of that inspection into sheet 2. I've been…
-
Formula If & AND referencing form another sheet
Is there a formula for the following scenario referencing from another sheet? if "checkbox = ticked under Unique column" AND "Fruit = Apple" Then display [color]@row Refer to below, result I want to get is "Green" =IF(AND({SheetA Range 3}=1, {SheetA Range 2}=Apple), {SheetA Range 4}) I tried with above formula, but didnt…
-
Incorrect Argument Set: Nested IF Formula with 3 Logic Statements
I have the following formula that works and I would like to add one more criteria, if Bid? = "Bid" then return 100% in %Complete Column This is the original working formula: =IF([Include in Estimate]@row = 0, 1, IF(OR(NOT(ISBLANK(Units@row)), NOT(ISBLANK([Fixed Cost]@row))), 0.25, 0)) This is my edit which returns the…