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.

Checkbox for consecutive dates (3 or more days and 2 or less)
Hi! I have a form that is used to track days a store location is closed. Everytime a store closes, the manager submits a form entry with the location name and the date of the closure. I would like to track consecutive closures for 2 days or less and 3 days or more. For example, Asheville, NC should be checked for…
Add month in a date
Hello,I searched the forum but couldn't find any formula that worked. I'm trying to add a value (value defined in a column) to a date. I try the formula : =DATE(DAY([Contrôle effectué en]@row:[Prochain contrôle]@row); MONTH([Contrôle effectué en]@row:[Prochain contrôle]@row) + [Fréquence d'entretien]@row; YEAR(([Contrôle…
Combining AVG/COLLECT/NETWORKDAYS
I am attempting to calculate the average number of working days it takes to complete a request, Criteria I want to base the data collection on include: urgency level Month and Year(I created a rolling month chart to see trends-see below screenshot) The Work Completion Date determines the month it will be reported on This…
How to Calculate Days Late Using Today’s Date When End Date is Missing?
This discussion was created from comments split from: Formula for delay between target and actual end date.
Sheet Summary Formula
Hello Smartsheet World! I have a question related to a sheet summary formula. I have a column with a drop down menu tracking facility issues. The users have the ability to select multiple issues in one submission. I am trying to count how many specific issues we are handling at a given time. For example, how many HVAC…
Need Help with IF Statement with Countif
Hi Smartsheet community. I have been working on a formula and it has not been working. Wondering if I am going about it the wrong way? I am working on a lessons learned project sheet where i am confirming if a root cause issue is being repeated or if it is new. This information is in the same sheet. My formula is below.…
How to use a formula to show the row # in a cell
I'm exporting a sheet and am trying to show the specific row number for each record. Do you know if there is a formula (i.e. =row) that will populate a cell in that record row?
Creating a Date completed Automation
I am attempting to create a formula that returns the date when my "Completed" column = 100%. Smartsheet keeps saying my syntax is incorrect. From what I can tell I need to use the TODAY function paired with an addition column that acts as a check to prevent it from perpetually updating the cell. In English the formula for…
Automatically updating/adding rows from a linked sheet
I have created effectively a 'dummy sheet' version of a Smartsheet for my implementation officers to use to use to request an update form for their item. The rows in the sheet are linked to the more comprehensive and detailed 'Full version'. However, if I add another row into the 'Full version' it does not translate to the…
Text To Column
I need help taking this string of text and creating column for each unique number sequence that is separated by comma. I was able to do the first column, but I'm unable to figure out the rest. Any help is appreciated.

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