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.

 

Sort Hot ▾

• Hot
• Top
• New

Discussion List

• How do I set up a 'running date column'?

  Similarly to a running total, I am needing to have a running date. So that every day it will move and change based on 'today'-- and referencing my start date column. How do I set this up?

  

  Answered

  Formulas

  functionality

  Formulas and Functions

  131

  Mar 24, 2020

  1

• Sum of column YTD

  I am not a pro with formulas, but I have been able to figure out most of the formulas I need by perusing this community. However, this formula comes up #unparseable with everything I do. Can someone h…

  

  Answered ✓

  Formulas and Functions

  271

  Mar 24, 2020

  3

• Formula help needed

  Hi guys I need help writing a formula. I'm trying to write a formula in which it calculates the fuel consumption for each truck for that specific date. What I was trying to say with the formula is tha…

  

  Formulas and Functions

  141

  Mar 24, 2020

  4

• Count if by date

  @Paul Newcome Hey Paul, I'm working on further automating the tracking sheet you've helped me with. My goal is to tally a task completion by date from our plant managers progress sheet, currently I'm …

  

  Answered ✓

  Formulas and Functions

  341

  Mar 24, 2020

  5

• Reporting: pulling in Parent Rows

  Hello, I want to have parent row pulled into my report. I used the following formula from one of the previous threads to automatically check parent row if a subtask is due to start in 30 days. However…

  

  Answered ✓

  Formulas and Functions

  212

  Mar 24, 2020

  4

• Cannot determine the needed formula

  I am needing to get totals for a column based upon a date. I am tracking daily personnel stats (4 different Columns/options) via form submissions. I need a total daily numbers for each column. Can som…

  

  Answered

  Formulas and Functions

  151

  Mar 23, 2020

  1

• Formula Using IFS, Contains, and AND

  I am trying to troubleshoot the following formula: =IFS((CONTAINS("Shadow", {GI Clinic 3 Session})), AND([Provider Last Name]3), "Scheduled") Logic: If the cross-referenced sheet (GI Clinic 3 Session)…

  

  Answered ✓

  Formulas

  functionality

  Formulas and Functions

  623

  Mar 23, 2020

  5

• Using dates without a date column.

  Hi, Is there a way to use dates in formulas without them being in a date column? I am trying to reference a drop-down column that has some dates in it and then take 42 days off of them. Is there a way…

  

  Answered ✓

  Formulas

  functionality

  Formulas and Functions

  512

  Mar 23, 2020

  12

• How do I automate At Risk flag to change to red 72 hours prior to deadline/task end date?

  Hi - I'm trying to automate the At Risk flag to change to RED 72 hours prior to the task deadline so it can trigger an email to the person assigned to the task. I have created the workflow/alert email…

  

  Answered ✓

  Formulas and Functions

  704

  Mar 23, 2020

  12

• If(And(Or

  I'm trying to create a formula that includes If, And, and Or in it and I'm having trouble figuring out the correct way to write it. Written out what I need is: If "restrictions in place through" is gr…

  

  Answered ✓

  Formulas

  functionality

  Formulas and Functions

  221

  Mar 23, 2020

  29

 

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list