Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.

Product questions?
Ask it here! The community's got your back.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

How to create totals for different columns for a specific date range
Hi I am struggling to get the total for all the columns in my sheet for each week Monday- Sunday. My entries are created via webform. I need to take into consideration the created date for my weekly time range Could somebody help me please? Thank you :)
Sum if formula based on condition in another cell
Looking for help on a formula! I want to sum the Forecast Amount values where the Sales Stage is equal to the value in the Status column. So for example, Status11 is equal to 2 - Qualification. I want the amount in Forcast Amount10 to be the sum of all the instances in the data below where the Sales Stage is equal to 2 -…
Formula to display duration of a project
Is there a formula or a work around to produce the duration of a project when given the start date of the project and the end date of a project? In Excel (=DATEDIF(D9, E9, "d") is a simple formula but in Smartsheet what am I'm missing?
Creating a New Sheet Referencing Cell Data from Other Sheets
In Sheet 1, I have several rows, each with information about a course being developed in a particular term. The sheet has a list of courses, within four parent rows, one for each quarter of the year (e.g., Parent Winter 2019, with several rows as children, one for each course to be developed in that term). There is a…
IF () formula, Change Status Dependate on Date
I would like to build a formula so that status will change to "Red" and type will change to "Renew" when date is past "Expire Date". I've applied the two formulas separately at the top of each corresponding column. But so far it just changes it to Red or Renewed automatically, without the date dependency. Can I make this…
IF Formula Based on Selected Quarter
Hi, I would like to write a formula that selects the appropriate sales tax rate with each quarter. I think I may be missing something basic when if comes to IF formulas...Does it matter if the sales tax column was created as a dropdown list? Is there a limit to the length of this formula if I were to add on with future tax…
Sumifs formula help
Hi, I am putting together a sumifs formula and it works for all criteria except this situation: With my working formulas, my range is just a column value but now I need a formula with the same criteria but I need to range to be the sum of 2 columns. This is my working formula with a single column range =SUMIFS({2019 Master…
Date Formulas
Is there a way in data matrix to do a formula to count the the number of lines with a due date today to 30 days out? I am trying to see item that will hit in the future.
Set Return Date as today +5
hi there, i have a form to manage my graphic designer's projects. It includes a To Graphics date and Return to You date. How do I set the Return to You date to be today +5 or greater?
Formula DATE
Hi I'm trying with the formula = DATE subtract months but I get #INVALID EJ: 05/18/2020 to 12/18/19, when I say that subtract 6 months I get an error but if the subtraction is within the same year the error does not come out, how should the formula apply? Thank you

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
AND-OR-COUNTIF Question
Hi, I started to build a formula and it doesn't return the required values. I have a sheet for distribution board testing. There are 25 yellow checkbox columns and 24 green checkbox columns. I have a column with 4 colour symbol (L1-Quad), and a checkbox column (All DB Tested) where the formula needs to return the value. My…
Formula produces #CIRCULAR REFERENCE
I'd like to compare the dates in two rows, i.e. Ende (Plan) and Ende (nach Verschiebung). If Ende (Plan) is older than Ende (nach Verschiebung) the date should change to red colour (or somehow be highlighted). The AI tool in Smartsheet proposed the following formula =IF([Ende (Plan)]@row < [Ende (nach Verschiebung)]@row,…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags