-
IF with multiple contingencies
=IF([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3 Weeks]@row > 5, "yes", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3 Weeks]@row = 5, "hold", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3…
-
Totals From SUMIFS Displaying Incorrectly Within Sheets and Dashboards
Hi all, Wondering if anyone has any ideas or insight into data not displaying properly within graphs on a dashboard. The issue I experience is that data displays during the wrong 'time' or is assigned to the wrong criterion. Here's the issue: I have a data sheet that gets multiple form submissions per hour - sometimes…
-
IF formula with AND OR nested
Hello, I'm attempting to create a formula that will determine if one or both options have been selected in a dropdown and assign that a numerical value. What I have now is =IF(OR([Communications provider]@row = "Provider A", [Communications provider]@row = "Provider B", AND([Communications provider]@row = "Provider A",…
-
countif with dates
Can anyone tell me what might be wrong with this formula? I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2018. Thanks =COUNTIF([Date Completed]1:[Date Completed]14, "=>1/1/18")
-
Smartsheet Formula to Click Active Checkbox in Next Row when Complete is Checked in the Row above
Title says it all but I'm putting together a workflow using hierarchy. We have certain tasks that have 6-7 phases in them before they are complete, and other tasks that only have 1 thing to do when they are complete, and I'd like to build an automated formula to check an "active" checkbox if something is a child row and…
-
Index match Help on formula
Hi All I have an index match formula that pulls info from another sheet from a status column made up of a drop-down with fifteen values. This is restricted to values. When I find the corresponding match, the formula works great, but if a value is not found, It returns a default value, which is not specified. I would expect…
-
I NEED HELP GET THE smartsheet equivalent to excel formulas
Formula A =IF((OR(B8="K",B8="PO", B8="", B8="via")),SUMIFS(Contract!R:R,Contract!E:E,C8,Contract!F:F,"0"),"NA") Formula B =IF((OR(B10="K",B10="PO", B10="", B10="via")),SUMIFS(Contract!R:R,Contract!E:E,C10,Contract!F:F,">0"),"NA") Formula C =IF((OR(B9="K",B9="PO", B9="",…
-
VLookUp - #INCORRECT ARGUMENT SET
Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…
-
How To Collect Data based on date and post to proper month column
Hi All! I have a several large projects running in a portfolio. The projects are all construction in nature and with each project there are subsections of construction each with target completion footage and target completion dates. I would like to build a report to show me the total build footage across the various…
-
Formula to count distinct values in a column that contain a certain text string
I am looking for a way to count distinct values in a column, but only if the values contain a certain text string. For example, in my Fruit column, I'd like to count the unique values that contain "Large." In this case, the number should be 3. Fruit Apple - Small Apple - Medium Apple - Large Orange - Small Orange - Medium…
