or Explore Discussions

# 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