-
If two conditions are met, then copy the value.
Hi Smart Team, I have two sheets A and B, both sheets have similar columns and metrics from two different systems, I want to create a third sheet and collate data as per condition such as if Date=Date and Queue=Queue then copy date for that day. I was able to gather data from System A, from System B, I'm not getting the…
-
Create Running Average
I need to create a new column with a running average based on the duration column, sounds simple, right? NOT! The issue is the data. In the screenshot below, shows the first section. In this instance the 2nd record shows the end date that happened first. So, as a result, that running average would be ONLY that one record.…
-
COUNT AND SUMIFS ... TO NOT INCLUDE CERTAIN CRITERIAS
Hi, I am wanting to =countif({Postcode 2}, does not contain any of the listed postcodes .... and then the same for a sumif however my brain is not working :( help please :)
-
SUMIFS to generate a running cumulative (based on date)
Getting an "Unparseable" error with this formula. Trying to add all values from "Unit Price" for dates in the Invoice Date column that are earlier or equal to the current row's Invoice Date. Text of formula is here to play with: =sumifs([Unit Price]:[Unit Price]@row,[Orig vs Invoice Add]:[Orig vs Invoice…
-
Get comma separated values from a cell and copy the values into independent cells
I have a column: "Materials QTY" values in this cell: "10,5,100,1400,11000,2" (comma separated no spaces). I have independent columns ie. "Material 1 QTY", "Material 2 QTY", "Material 3 QTY" up to 20. I need to extract the 1st value from the "Materials QTY" and populate it in "Material 1 QTY"; the 2nd value from the…
-
Approve / Reject button side by side in a form
Hi, i am trying to create a form with approve / reject button side by side. Is this possible?
-
Limiting chart limit to a value
Hi, I have created a chart widget in Smartsheet dashboard and I would like the horizontal axis to go up to the value of 100 only and not 120. Is there any way to bring it to 100? Please see attached images of the chart and the data that the chart is using to build the chart.
-
Building Smartsheet
I am working on building out a form that has many different options and was wondering if there was a way to setup the smartsheet to expand the specific product details if the product name is selected. For example - I have 2 products - Individual Accident and Accident 1.0. I don't want all the options for each product to be…
-
Formula Help!
Hi, I am trying to edit an existing formula in SmartSheet to add another criteria and it won't work! In the same row, I want to add (LAL@row * 131.25) in addition to the formula below. For some reason it breaks all of the formula. Please help!
-
Formulas between sheets
Hi there, I am trying to add up some numbers found on one sheet in a second sheet, but only when certain criteria are met. I believe this should be a SUMIF formula, but I'm not sure how to make both the reference to a different sheet and the criteria work together. The closest I can wrap my head around is…