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

• Create a formula that returns the current project phase in the project summary metadata sheet.

  The phases in my project plan are Level 1. The formula should return the text value of the phase (task name) that has the least % started, NOT including phases at 0% or at 99% and higher. =INDEX({Task…

  

  Answered ✓

  Formulas and Functions

  511

  Nov 1, 2022

  5

• SUMIFS Formula Help

  Hi there, Super stuck on how to get the below working, any help/advice about where I am going wrong would be greatly appreciated. Smartsheet 1 - Data Sheet, where: Range 1 = Dropdown list column Range…

  

  Answered

  Formulas

  Formulas and Functions

  191

  Nov 1, 2022

  6

• Track Project Changes and showcase the ripple effect

  Hello SS Community :) I was wondering if anyone knows of a way to track project changes and more so how to showcase the ripple effect of that change. I guess sort of a what if analysis, if I pushed th…

  

  Answered

  Formulas and Functions

  142

  Nov 1, 2022

  1

• Counting # of Overdue

  Hi, I am trying to count the number of Overdue rows using two deadline columns (Due Date 1, Due Date 2) and a Status column, so using both of these criteria: Determine if the deadline has passed from …

  

  Answered

  Formulas and Functions

  301

  Nov 1, 2022

  8

• Is it possible to display a graph from an excel file hosted on Sharepoint on a Smartsheet Dashboard?

  I understand it would be possible to upload the excel file into Smartsheet and display it that way. I'm looking to see if I can link to the excel file itself and have the excel graph displayed automat…

  

  Answered

  Dashboards

  Formulas and Functions

  1160

  Oct 31, 2022

  2

• Index Match (No Match)

  Im pulling in information from another sheet to the sheet in the image below and I cannot figure out how to only make the date show up when there is a match. I do not want "No Match" to appear. =INDEX…

  

  Answered ✓

  Formulas and Functions

  211

  Oct 31, 2022

  2

• Possible to use cell linking for formulas?

  I have multiple sheets that are set up in the exact same way, used by various team members. Each sheet has several formulas. If there is an update to the formula, I have to go into each sheet and adju…

  

  Answered

  Formulas

  Cell linking

  Formulas and Functions

  191

  Oct 31, 2022

  2

• Calculate time

  Hi Everyone, years ago, I was told that smartsheet does not calculate time. Has the ability to calculate time been added? It would be nice to move this task over to smartsheet from Excel. I am looking…

  

  Answered ✓

  Formulas and Functions

  1576

  Oct 31, 2022

  4

• Approval Workflow Not Triggering

  I'm trying to set up an approval workflow when a submitter doesn't give a 90-day notice for a meeting request on Smartsheet. Every way I set it up, it won't trigger!! I require a 90-day advance notice…

  

  Answered ✓

  Formulas and Functions

  414

  Oct 31, 2022

  4

• Could anyone help with solve this issue

  I have 12 questions in a call audit smartsheet so the formula is as follows =((COUNTIF([Question1]@row:[Question12]@row, "poor") * 0.25) + (COUNTIF([Question1]@row:[Question12]@row, "fair") * 0.5) + (…

  

  Answered

  Formulas and Functions

  151

  Oct 31, 2022

  1

 

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list