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

• Alerts for max rows

  Background: Shift information is typed into a main sheet in multiple columns/rows by multiple people, then at the end of the shift, the manager confirms the date, shift number, and shift information b…

  Answered ✓

  Formulas and Functions

  644

  Mar 17, 2025

  10

• Formula result can't be copied and pasted correctly

  I am using a formula that takes the value from several columns to generate a job name and number. It works beautifully but for some reason, it's putting a space after each "_" and so I have to use "wr…

  Answered

  Formulas

  Formulas and Functions

  11

  Mar 17, 2025

  1

• SUMIFS statement not working as intended.

  I have a SUMIFS statement that I am trying to calculate a total of $ if it meets two criteria from another sheet. I am looking for it to meet the criteria of RRC Status: Engaged and RRC Pathway: Essen…

  Answered ✓

  Formulas

  Formulas and Functions

  31

  Mar 17, 2025

  4

• Previous Formulas and Cells Linked

  I have taken over a previous built smartsheet with multiple formulas that connect between multiple sheets. I have made a change and now none of my formulas are working and I can't locate the original …

  Answered ✓

  Formulas and Functions

  1

  Mar 17, 2025

  1

• Calculate multiple stages

  Hi, I have two columns: "Sales Rep" and "Sales Stage." The "Sales Stage" column contains these options: Proposal Qualification Needs Analysis Negotiation Stalled Closed - Won Closed - Lost I want to c…

  Answered

  Formulas and Functions

  1

  Mar 17, 2025

  1

• Trying to find duplicates in a column so I can alert the submitter and remove the row.

  After much research, I am still stumped. I have set up a Smartsheet that will allow users, via a form, request a date and time slot for hoteling (work desk reservation). I have a link in the form to t…

  Answered ✓

  duplicates

  Formulas and Functions

  36

  Mar 17, 2025

  3

• How to display names instead of email + names when making a bar chart with a contacts column?

  Hi! I'm trying to make a bar chart that shows # of tasks for each person in the project. I used the contacts column, and it shows as just their names in my sheet, as well as in the report I am pulling…

  Answered ✓

  Contacts

  Dashboards

  Formulas and Functions

  2

  Mar 17, 2025

  1

• Formula Error Message

  I am working on a formula that calculates the balance of funds and once the General Funds Balance is zero then the formula would be using the Special Funds $1,000 column. So the new formula would be S…

  Answered ✓

  Formulas and Functions

  15

  Mar 17, 2025

  8

• Date Formula for the Monday following a Date

  I'm looking for a formula or automation that calculates the date of the Monday following a specific date. The initial date may be a Tuesday, Wednesday, or Thursday, but the date I need to "fill in" wi…

  Answered

  Formulas

  Formulas and Functions

  817

  Mar 17, 2025

  2

• Nesting DISTINCT into an AVERAGEIF formula

  Is it possible to use the DISTINCT function within the AVERAGEIF function? I need to average the number of days a PO has been on order if a specific purchase group number was used to create the order.…

  Answered

  Workspaces

  Formulas

  Formulas and Functions

  11

  Mar 17, 2025

  3

 

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list