Formulas and Functions
Archives for March 2018
Discussion List
-
Referencing sheetsIn Formulas and FunctionsI am trying to decide between one sheet vs multiple sheets. I currently have one sheet but it has over 50-60 columns and there are sets of data that will be used by different areas. I know I can filter what is needed (to a point) with re…
-
Status Balls formula helpIn Formulas and FunctionsHi, I am very new to this an am getting a bit frustrated. I have the following columns, Ship Date, Fabric Order Date, Fabric ETA, and Fabric Received or In Stock. The first 3 columns are date columns and the 3rd is a checkbox. I would …
-
IF WITH 2 CRITERIAIn Formulas and FunctionsI'm looking to make a formula that will do the following: search all instances in Column2 for "A" IF subsequent Column3 has a value of "YES"....if all "A"s = "YES" than return a value of "YES&…
-
Multiple reference FormulaIn Formulas and FunctionsGreetings: Trying to create a formula that tracks task duration displayed by "symbol" in conjunction with another condition of the task:... complete, or not started. I was able to get the symbols to show up properly based on c…
-
Count of cells in a date rangeIn Formulas and FunctionsHello, - I am fairly new to Smarsheets and not very knowledgable past basic formulas. I am trying to create a formula that will display the count of cells whose date is from Monday through Sunday, each week. Like how many open items wer…
-
RYG Balls-can't figure outIn Formulas and FunctionsI've looked and cannot solve a problem I had solved before... I have a checkbox to denote when a task is completed. I have a due date. My problem is that I want my RYG to be green if the box is checked (that seemed easy to do) and Yello…
-
Using countifs across sheets to hold metrics for reportsIn Formulas and FunctionsWe have a sheet that lists all of our projects (there are over 300 at the moment). We used to keep all of our metrics at the top of the sheet, but every now and again, someone would sort by a value that caused the metrics to get mixed into…
-
Formula using Sum and Countif not returning expected outcomesIn Formulas and FunctionsHere's a version of the formula that works. However I need to include a second value and get an error when I try. I'm sure it's the formula syntax. Not sure if there is a better way to get the right outcome. I basically am trying to determ…
-
Formulas in Columns with Dependencies?In Formulas and FunctionsIs there any way to work around dependencies in columns when entering in formulas?
-
Formulas per columnIn Formulas and FunctionsHello, Smartsheet team: If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. Unfortunately, I need to do this for 300,000 rows! …
