Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Counting Concurrent JobsIn Formulas and FunctionsEach row in this spreadsheet is a "Job". I'm trying to count (project the count by month) concurrent "Active" jobs (rows) based on a start and finish date of the job. I created two columns (per 12 months) to set the cr…
-
How to find the largest Items in a list and their corresponding Item names?In Formulas and FunctionsHi, I'm trying to identify the TOP 5 most Requested Items in my Inventory list. I have a formula in place that finds the value of the Top 5 (Formula #1); however, my formula (Formula #2) that finds the corresponding Item Names of the TOP 5…
-
Is there a formula that will automatically add zeros in front of numbers added to a cell?In Formulas and FunctionsIs it possible to have this number show, 000000065145, while only typing in 65145? I need to have seven leading zeros before the number.
-
It's Only Blocked Until I Kick ItIn Formulas and FunctionsI have a formula that leverages some sheet summary formulas and returns a true/false to support a report filter. When I change data in the sheet the sheet summary formulas sometimes return a #BLOCKED, but it is not consistent. When it do…
-
COUNTIFS referencing date ranges specified in Sheet SummaryIn Formulas and FunctionsI'm trying to count the number of cells (dates) that fall between two dates that are selected in sheet summary. In excel I've been able to make this work =COUNTIFS($C$7:$C$47,">="&$H$1,C7:C47,"<="&$H$2) H…
-
Anyone let me know why this Formula is failing to workIn Formulas and FunctionsIt says INCORRECT ARGUMENT SET?? =IFERROR(VLOOKUP([Description List]1, {TGS Part No}, 3, false), 0)
-
How to add percentage with a blank cell and get the result in percentage format?In Formulas and FunctionsHello everyone, I am adding 2 different Efficiencies to show the Total efficiency. When there are values in the cell it works just fine, but when I am adding a percentage with a blank cell (or even a Zero) , the final result doesn't get co…
-
Sheet Summary formula for counting unique values within a multi-select dropdown column?In Formulas and FunctionsI am trying to count the number of unique systems used within a workflow. I have dozens of possible internal systems listed within a restricted, multi-select, dropdown menu. As these systems are populated to the grid (sometimes multiple wi…
-
Alphabetize Using FormulaIn Formulas and FunctionsIs there a way to easily alphabetize a list using a formula in smartsheet? In Excel, I would use the simple formula shown below to assign a numerical value to each unique list item. =COUNTIF([Unsorted Range],"<="&[Specific…
-
Status FormulaIn Formulas and FunctionsHi all, I am struggling to create a formula that works and wonder if you can help me…. Duration Equal to or Less than 0, Gray. Duration Greater than 0 but “Email Sent” & “Return Old Device” unchecked, Yellow. Duration Greater than 2…
