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.

Why would these Countifs not work together?
I need to know how many second drafts required minor or major revisions. These are the two sets of countif functions I need: =COUNTIF({Completed Reports Draft No.}, =2) — answer returns fine at 11. =COUNTIF{Completed Client Comments}, "Major Comments, DCF Needed") — answer returns fine at 10. However, when they are put…
Row Report - Multiple Sheets - Remove Duplicate Rows
Good afternoon, I am working on creating a row report using multiple sheets of mostly the same data. Starting with sheet one, at sheet 2 the row is 'moved' and more data is added and sheet 3 the row is copied and more data added. I have created the report pulling all the data in, and was able to find a filter successfully…
I have a formula that is 1,701 characters. Smartsheet will not allow me to add to the formula. Why?
COUNTIFS and SUMIFS formulas with multiple criteria AND a dynamic date range in a sheet summary
Hi everyone, I've had a look in the forum threads to try and find an answer already, but not sure what I'm trying to do is like-for-like with some of the suggestions. BACKGROUND: I'm helping colleagues with aggregating some of the data in their deployments sheet, which they use for managing and tracking their events, the…
Index/Match in different scenarios on same sheet
So far I've been successfully working with index/match to pull certain names (PM/Supervisor, Additional CC) when a certain requester is used on a sheet. Now I have a requester that is assigned to two (2) different clients, but the PM/Supervisor and Additional CC are different people per client. How can I incorporate that…
Alphabetize Using Formula
Is there a way to easily alphabetize a list using a formula in smartsheet? In Excel, I would use the simple formula shown below to assign a numerical value to each unique list item. =COUNTIF([Unsorted Range],"<="&[Specific Cell Value]) This formula doesn't work in smartsheet, so I'm trying to find a solution. I am working…
Help with formula to check the lowest hierarchy row per branch where FX = 1
I'm trying to create a formula in Smartsheet that checks the box only for the lowest hierarchy row in each branch where the FX column shows "1". Column "A" represents the hierarchy level. Column "FX" contains the FX rate, and I only want to check rows where FX = 1. 🔹 The checkbox should be marked only for the lowest row in…
How do I make a double line graph?
Hi everyone, So, I am trying to chart some data on a double line graph, but I can't seem to figure out how I should go about doing it. I am familiar with how to make graphs on the dashboard from a report, but I only know how to make a single line graph. Here's what I'm trying to achieve: I want to chart specific "reasons"…
Why won't Index and Match column formulas work past row 1 on destination sheet?
I'm working on developing a PMO solution and have started with the suggested intake and portfolio metadata sheets. I have set up Index and Match formulas to pull information from the intake sheet into the metadata sheet and they worked beautifully for the first row of data. However, when I entered a few additional test…
how to "save" data from past weeks?
I have a filled used by multiple users to populate their ongoing tickets. Tickets are entered by someone with an open status and they evolve trough different status until being closed. One line is used per tickets and we just changed the status as the activity progresses. I would like to do KPIs of the number of tickets…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Does NOT contain formula
I am trying to create a formula that looks at 2 different columns Term Ending Date and Amendment - Ending Date. If column Amendment Date does NOT contain N/A it should return the value in [Amendment - Ending Date] @row. This part of the formula works I can't get the third party to work. The third part should say if it DOES…
Count value in columns
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up this formula? I tried several one but not found the best. The result will be shown in the blue column, this will be 0, 1, 2,…
Formular Workday Count
Hello, I've formula use Workday to count Due date = Start Date @row cell + option days. fx Image below: Start Date is 04/24/25, then added 11 days = Resulted 05/09/25 as Due date. Now, out of curiosity added days manually = Resulted 05/08/25 as Due date. Some folks prefer manual counting😓. And I need to able to understand…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags