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

  • Revising duration so it doesn't count first day
    In Formulas and Functions
    I want the range of days from Monday the 1st to Monday the 21st to read 21 days; yet it reads "22 days" in the duration column.  This is because day 1 is the first day, when I need "day 1" to be the following date from …
    20 1
    20 views 1 comment Most recent by Mike Wilday
  • Combine IF formulas in one cell
    In Formulas and Functions
    Hello, I'm trying to create a %Complete column based on a drop down list column called "Status".  For example, I'm looking to combine these formulas into one cell, then copy and paste to all other cells in the same column.  I'm …
    478 2
    478 views 2 comments Most recent by pyennaco
  • Criteria for Alerts and Actions Rule
    In Formulas and Functions
    My boss has a Smartsheet set up to send a Update Request 30 days before today.  For example row 7 would look like ....=[Due_Date]7 - TODAY() Would this alert still be sent if Smartsheet was down for maintenance at the scheduled time the a…
    18 1
    18 views 1 comment Most recent by Mike Wilday
  • Formula Help
    In Formulas and Functions
    Hello New user needing help with formula. I would like it to be something like this: When the due date is => than today -1 turn red, if the due date is < today - 3 days turn yellow, if due date is is =. than today +5 turn green T…
    122 9
    122 views 9 comments Most recent by Mike Wilday
  • Column Status Formula
    In Formulas and Functions
    Hi Everyone,  I have a status column with the following options: Not Started, In-progress, Complete, N/A. I've created a formula if the parent row is set at 'Not Started' then the sub-task would automatically change to 'Not Started'.  Sa…
    42 1
    42 views 1 comment Most recent by aguillot
  • Parent Sum IF
    In Formulas and Functions
    I've tried a variety of calculations, and can't seem to get the results I'm seeking.  I'm simply trying to add up all of the parent rows in a column called Resource Days that are Assigned To a specific team member.  Any suggestions? =SUMI…
    276 1
    276 views 1 comment Most recent by J. Craig Williams
  • Enhancement Request: Report Criteria What? on Dropdown column like Text/Number
    In Formulas and Functions
    When I have a Dropdown column for the What? criteria of a Report, my only option is some version of the "is one of" criteria. What I want is to be able to build the criteria like a Text/Number column, for example using "con…
    61 1
    61 views 1 comment Most recent by Shaine Greenwood
  • Count & AVG only if another column contains "text"
    In Formulas and Functions
    Hi Again, After scouring discussion boards I have managed to Average the total of the rows, see below =IF((COUNT([Days to respond]194:[Days to respond]214)) = (COUNTIF([Days to respond]194:[Days to respond]214, 0)), 0, SUM([Days to respo…
    46 2
    46 views 2 comments Most recent by J. Craig Williams
  • Saving original cell value in another cell
    In Formulas and Functions
    I have a cell that holds a target date (Target Go-Live Date) and another cell that I want to hold the original date entered in the target date cell.  This way if the Target Go-Live Date is changed, the other cell (Original Target Date) has…
    105 2
    105 views 2 comments Most recent by J. Craig Williams
  • Help with nested IF statement using AND
    In Formulas and Functions
    Hello Community, I have created the below formula that SEEMS to be working but is not showing up with the color coding that typically happens when you have all your formula ducks in a row.  It is returning a result, not an error, but I’m …
    17 3
    17 views 3 comments Most recent by Katie Williams