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?
Sign in and 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.

Why isn't this formula working anymore
How to assign points to answers selected thru drop down on form
Hello, I created a form to be used during a training exam. Each cell has a drop with 3 options, Proficient, Needs Improvement, Not covered. Is it possible to assign each option a point value ( 3 - proficient, 2 Needs Improvement, 1 not covered) and have a total calculated once completed? Thank you
How to create a formula with multiple criteria with OR logic?
Hi Team, I would like to create some formulas with multiple criteria where some should work with OR logic. Could you advice if this is possible and how should I proceed? Example: From the sample data below, I would like to calculate: How many tasks there is that are being worked on (Task Phase is "Started" or "In…
After filtering based on a criteria, is there a way in which I can mass delete all the other rows?
Basically, I want to filter for rows based on certain criteria and after that I want to mass delete the other rows which don't fulfill that criteria. We're doing this as clean-up exercise. Any tips?
Building a sheet to best populate dashboards
Do you have any training material you can share on “best practices” for building a project plan/timeline to populate Dashboards correctly (e.g. metrics and tables). Examples of things I want to do: Present the overall project health as red, yellow, green; sum of late tasks; sum of tasks in progress and on-track; sum of…
How to extract Month only from Date column format eg. Apr 6, 2021
Hi All, I am a novice in Smartsheet Functions and need some help. How can I extract the month only (i.e. Apr) from Date column format e.g. Apr 6, 2021 in the same Smartsheet? Thanks. Janice
Help! How to pull information from last updated column?
Hey everyone, Hoping someone can help me figure this out! We have a sheet we are using to track weekly maintenance on our machinery. There is a parent row with the machine name and the actual checks are the collapsible rows underneath. The checks are filled out by operators on another report/form so this sheet gives the…
How to create if/then formula to identify differences in text columns
I'm trying to automatically identify whether PIs in my departments are collaborating on various projects. I'm essentially looking for a formula that will identify in a column when up to 4 departments are not equal. Suggestions?
Sheet reference Countifs formula with a date
Hello, I have a column that's a date and need a formula on a separate sheet to count if the date is current year. I haven't been able to find any community posts about sheet references, only cross sheet ones. Current formula: =COUNTIF({Date Column}, ISDATE(>2023)). I get an invalid ref error.
Bi-directional sync for linked cells
Can we create a bi-directional sync between 2 linked cells from 2 separate sheets

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Help to count data
We have lot of tasks completed on different months on that how to calculate number of tasks completed on specific month for example on Month July 2023 with a condition that value shows Current=YES.
Formula Issue
Hi all, I am trying to average the values in a column, 'Defective Quantity', when the value in column 'hide' is an '11' (for month) AND the data in column 'Year' is 2023. =AVERAGEIF([Defective Quantity]:[Defective Quantity], hide:hide, =11, year:year, =2023) I am receiving an #UNPARSEABLE error. Any idea what I'm doing…
Marrying three formulas together
I have three different formulas, containing various criteria, which I want to want to marry together and for which all things must be true: 1) project start date is less than 1/1/24; 2) go-live date is greater than 12/31/23 and 3) the project stage is "In progress" or "Waiting to start": =COUNTIF({HR Projects Project Start…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags