Formulas and Functions
Archives for December 2018
Discussion List
-
Auto fill column?In Formulas and FunctionsHi, everyone. I don't know if this is a possibility or not but I'm hoping someone can help. I'm looking to see if it's possible to set a formula/equation/conditional formatting so that what's entered in one column will autofill another. …
-
Start & Finish dates based on separate predecessors / or formula in durationIn Formulas and FunctionsI am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a star…
-
How to I "not format" a number in a form?In Formulas and FunctionsOne of the questions on my form is what year(s) someone attended our annual meeting. The format is text/number. if someone attended in 2016, 2017, and 2018, the answer is being formatting with commas and displays as 201,620,172,018 even th…
-
How do I use a countif formula to count the number of various priorities?In Formulas and FunctionsI have a column for priority which returns symbols. Exclamation = high, dash = medium, and down arrow = low. I have tried various formulas and nothing is working. I basically want to know the amount of highs, mediums, and lows in my s…
-
Linking smartsheetIn Formulas and FunctionsI have a master sheet that I am using to pull in data from the child sheets (linking). The child sheets are dynamic and new parents and childs could be added. 1. When linking i lose child sheet hierarchy on the master sheet. How do i main…
-
Score FormulaIn Formulas and FunctionsI've created a scorecard in smartsheet and want to create a formula that does not allow the scorecard score to show as more than 100%. I think is should be something like If score >100%,100% but am not sure what the entire formula sho…
-
Formula to calculate the Next [Future] date in a string of datesIn Formulas and FunctionsHello, I'm looking for a way to find the next task due date. Ideally, I'll be able to look at a row with several date columns, and determine the next date. This would be the MIN Date that is Greater than Today's date. I can easily get t…
-
COUNTIFS for 2 and 3 criterionIn Formulas and FunctionsHello, I am trying to have my formula count when the row has "Ken Mallory" for the name column and any date that equals January. This is what I have so far but it is Unparseable. Thanks for your help:) =COUNTIFS({Master Compli…
-
VLOOKUP for attachment on another sheetIn Formulas and FunctionsSmart sheet enables the user to upload attachments, which is useful. So what I do for my workflow is I have a full sheet dedicated for part number and part information, so when I type in a part number on the work order sheet it auto-fills …
-
Value functionIn Formulas and FunctionsHaving trouble with the formula below. Version 1 works and extracts what I need from a cell. I need to then convert that to a numeric value. Currently I get #invalid value. I'm missing something, and I bet it's dumb. ;) * =MID([Active …