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

• Count Project Categories + Count if Before a date

  Hi! I want to work out a total number of files we have overdue. I have got as far as adding up all projects that do not include the category completed using: =COUNT([Project Category]:[Project Categor…

  Answered

  Formulas

  Formulas and Functions

  21

  Mar 6, 2025

  4

• What column type is required to use MONTH to return number of new lines in a certain month?

  I've been trying to count lines by month, I have the column I want searched set to a date column type. =COUNTIF([Date Opened]:[Date Opened], MONTH(1)) I'm getting a invalid data type error.

  Answered

  Formulas and Functions

  1

  Mar 6, 2025

  1

• 2 sheets for daily production and production schedule for a PO (month) =Status

  I have two sheets. One sheet for tracking daily production and another sheet that tracks the production for the month. I have a status column that matches on both sheets. On the production schedule I …

  Answered ✓

  Manufacturing

  Formulas

  IT & Operations

  Formulas and Functions

  21

  Mar 6, 2025

  2

• IF INDEX MATCH yielding INVALID DATA or NO MATCH

  I am creating a formula to look at an instructor's name on one sheet and see if it exists on another sheet (verifying that a qualification has been completed). My formula sort of works, if there's a m…

  Answered ✓

  Formulas and Functions

  21

  Mar 6, 2025

  4

• Help with COUNTIFS function

  I am trying to create a COUNTIFS formula to populate a dashboard and can't seem to get it quite right. I am sure it is a very minor issue but was hoping for some help. In the sheet below, I want to cr…

  Answered ✓

  Formulas

  Dashboards

  Formulas and Functions

  21

  Mar 6, 2025

  4

• CountIF formula between two sheets

  Hello, Can someone please point out what's wrong in this formula: =(COUNTIFS({Applied Grants}, "Applied", {submission date}), AND(@cell >= DATE (2025, 1, 1), @cell <= DATE(2025, 12, 31)) I would like …

  Answered

  Formulas

  Countif

  Formulas and Functions

  1

  Mar 6, 2025

  1

• How to Calculate Week Number and total work done within a week

  I am trying to calculate total work done within a week for a job and previous week as well.

  Answered

  first day of week

  Formulas and Functions

  11

  Mar 6, 2025

  1

• Having issues with Year formulas

  I have tried several year formulas, none of which I have found to be accurate. I have tried dividing the days by 365 and using rounding but the rounding doesn't work for half of the year. The current …

  Answered ✓

  Formulas and Functions

  61

  Mar 5, 2025

  7

• Formula Help

  I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…

  Answered ✓

  Formulas and Functions

  11

  Mar 5, 2025

  2

• Automated Workflow Not Updating Cell

  Program Managers are required to submit updates on the progress of a program development every two weeks, across Stages 1, 2, and 3. Ultimately, they will submit multiple updates while a program is at…

  Answered

  Formulas and Functions

  11

  Mar 5, 2025

  1

 

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list