-
Copy the value of a cell when columns contain certain text
Above is my reference sheet. On a separate sheet I need to create a formula that returns the value in [Count] when the [Org] = "MSCL", [Type] = "M", and [Metric Category] = "01 - Active". This reference sheet will be uploaded in data shuttle monthly and the data I'm looking for may not always be in the first row. I'm new…
-
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…
-
Countifs and the use of OR
I am currently using the Countifs function to count the number of "Yes" responses to several questions that are asked using a SmartSheet Form. Some of the questions are designed in a way that does not capture anything creating an empty field in the question for a particular row. I need to be able to count "empty" fields as…
-
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…
-
Web-based API and Dynamic Search
Can we have a prettier way to search Smartsheet data and change filters dynamically in a dashboard?
-
Need a box checked if one of two criteria is met
Hi! I have a column and I need the box to check if a student's disability is Intellectual Disability or Multiple Disabilities. I have the formula correct if it's just one: =IF([Primary Disability]@row = "Multiple Disabilities", 1, IF([Secondary Disability]@row = "Multiple Disabilities", 1, IF([Tertiary Disability]@row =…
-
If And Drop Down
Hi i have 3 column's, col 1 = Small Diamond Size, "0.01-0.07" col 2 = Smalls Diamond Grade, "IJ" IF ABOVE TWO THEN Col 3 = 400 col 1 = Small Diamond Size, "0.01-0.07" col 2 = Smalls Diamond Grade, "GH" IF ABOVE TWO THEN Col 3 = 500 I have tried this - it does not work please help =IF(AND([Small Diamond Size]@row =…
-
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…
-
Need to find the amount of time that a row stays in a certain stage
So, I have a Legal Contract sheet that tracks all of our legal contracts that our in-house counsel are working on. We have a stage or status field that we use to show the stage of the contract. They would like to track the time that a contract sits in a specific stage. So If on day 1 it starts in the first stage, and then…