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

Can a formula determine hierarchy?In Formulas and FunctionsI doubt this is possible but thought I'd ask anyway. I want to know if there's a way to indent a row with a formula. So if a user submits a form and indicates that it should be a child row of a specified parent row, would it be possible to…

Countif on filtered list or a range based on a value on another columnIn Formulas and FunctionsI use the following function to count "=COUNTIF({Cell Range 2}, 0)" numerical values from a column. However, I should only count the cell values when a cell value in the same respective row but in another column is blank. Not s…

Date formula to reference another cellIn Formulas and FunctionsGood Morning! I'm seting up a metrics spreadsheet with a lot of formulas. The person who will be administering it in the future isn't really familiar with formulas so I'd like to make it as easy as possible. I created a formula that doe…

Formula for text columns convert to sum?In Formulas and FunctionsHello, I'm trying to help build a sort of prioritization scorecard into a sheet. We have 4 columns, each with possible values of (example) "A", "B" or "C", and would like to have another column that sums ea…

Incomplete work left to goIn Formulas and FunctionsIs there a way to calculate work days "left to go" where the task is not marked complete while ignoring simultaneous tasks (tasks that have the same predecessor)? It seems like networkdays should get part of the way there but it…

IFS StatementIn Formulas and FunctionsI have the following equation I am trying to get working: =COUNTIFS({Range 1}, =1, {Range 2}, IFERROR(YEAR(@cell), 0) = 2018, {Range 2}, IFERROR(MONTH(@cell), 0) = January, {Range 3}, OR(@Cell="", @Cell="")) The equatio…

COUNTIF Formula for when a cell contains a specific word/phrase?In Formulas and FunctionsI'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. …

Check Box & IF StatementsIn Formulas and FunctionsAppreciate some pointers on this if possible.. I have 5 Columns in my Smartsheet.. the first 4 are Check Boxes, the 5th is a Text/Number.. Columns as follows.. [North] [East] [South] [West] [Direction] In [Direction], I wan…

IF Percentage Complete = 100% return DateIn Formulas and FunctionsThis seemed simple to me before I started.. but this has me foxed..! two columns: % Complete [Text/Number field] Date Complete [Date field] What I intended is for the Date Complete cell to automatically complete with TODAY() when …

Formula Help NeededIn Formulas and FunctionsI currently have 3 Columns: Column 1 "NUMBER OF UNITS", Column 2 "UNIT PRICE" & Column 3 "TOTAL PRICE". What I am trying to do is if in Column 1, the "NUMBER OF UNITS" is 600 or less, I need Col…