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.

Auto populate Parent Rows
Is there a way to copy formaulas on parent rows of a plan? If my users add more rows I have to find the new rows and copy the formula e.g. Min/Max on parent rows. It would be great if SS could auto-populate the formula when new rows are added. Any ideas?
Count If Help please
Hi I am trying to count the number of cells that contain a date, I have tried the below, but no luck =COUNTIF([Date of 1st Test]@row + [2nd Test Date]@row + [3rd test Date]@row + [4th Test Date]@row + [5th Test Date]@row + [6th Test Date]@row + [7th Test Date]@row + [8th Test Date]@row + [9th Test Date]@row + [10th Test…
If Formula not working
Hi I cannot get the below if calculation to work, any suggestion where I have gone wrong? =IF([Customer]@row "M&S", [Trial Date]1+1, IF([Customer]@row "JS", [Trial Date]1+12, [Trial Date]1+8)) Thanks Kate
Column formulas
Can I assign a formula to an entire column so I don't have to keep copying the formula to the next row?
AVERAGEIF Formula
I am trying evaluate an entire column of data and average data in that column based on date entries in another column and have been having some difficulties doing that. I've been trying to achieve this using the AVERAGEIF formula something else embedded in there but haven't had any luck.
how to get a form on smartsheet to automatically send to a certain manager based on type
In a recent video that was posted by John Cicero, he spoke about having the form automatically update the sheet with which manager that intake request should be submitted to. He used a "Match&Index" formula, although he did not show us the steps on which how he did this. I tried to read the help pages on Smartsheet showing…
Adding attachments to Forms
Hello: I am wondering if there is a way to send a form with an attachment for people to review and then select "acknowledge". Similar to an Update Request but without having to go into SmartSheet.
IFERROR and Nested IF Statement
Hello, I would like to incorporate an IFERROR into my IF statement, to weed out the pesky #NO MATCH error. I'm using the formula on a checkbox column and I want it to return a check if the Audition Status column contains Reject or On Hold and be unchecked if the Audition Status column contains anything else (Awaiting…
OnCriticalPath in a formula?
Hi - Anyone know of a way to build a formula that determines if a row is on the critical path? It looks like, although we can filter rows by critical path we can't access that tag within a formula. My goal is to add a column called "on critical path?" that is checked if the row is on the Critical Path, and unchecked if it…
Count non repeated
how can i count those items in a column are not repeated?

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

Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags