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.

Is there a way to reflect delays in a Project Plan without losing the original dates?
Looking for the best way to reflect delays in the Project Plan without losing the original dates, instead of just adjusting due dates? We would like to figure out a way to show that something is late, or the date by which it was completed.
JOIN / COLLECT CHILDREN TEXT
Hi All, I'm stumped trying to get a join / collect statement to work. I have Ancestor / Children columns set up, and on the Ancestors = 0 rows, I would like a text string of the column QLICI ID summarized for all Child rows - separated by a dash and return. Here is what I have currently, but its not working:…
Copy data entered on secondary sheets to "primary" sheet.
We are setting up a project approval process. We have a primary “Intake” sheet where initial project data is entered. In many cases, users will be providing project budget and resource information later. We do not want them entering data directly on the sheet so would like to use supplemental forms. My understanding is…
Extracting the LATEST Date
I have three columns each will have a different date in it. I want to write a formula in a fourth column which pulls out the Latest date of those three columns and records that date in the fourth column Example: Column 1 - Date resume reviewed 03/15/22 ; Column 2 - Date Licensure Reviewed 04/01/22 ; Column 3 - Date…
How do I use an automation to clear the value in a drop down column?
I have a simple drop down column and need to reset it to blank in some circumstances. However, the automation for "Clear Cell Value" does not seem to work with drop downs. Nor will "Change Cell Value" b/c you can't add a blank option to a drop down. Any insights would be greatly appreciated, @Andrée Starå @Paul Newcome .…
Automatic Date when Dashboard is updated
Looking all over but cannot seem to figure it out. Is there a way to have the date automatically logged in a field every time the dashboard is updated / Edited.. ??
How to remove the 2 apostrophe while scannig the barcode
Hi All, I hope all are doing great I just wanted to check how I can remove the 2 apostrophes from my cell value as I scanned the barcode and I got this value ''0987654321. As I used the VALUE formula but it is not working for apostrophes. Thanks for the help!
Best formula to use for replacing data in a cell from referenced sheet
Currently using referenced sheets to keep track of clients that are contacted, and what is discussed on those calls. Agents use a form to fill out cells in rows based on a client assigned number. The assigned number is what is used as reference for INDEX and MATCH formulas on another sheet, which is working fine. However,…
Counting number of times a deadline is missed
I need a formula for a sheet summary that I just cant wrap my head around, might even be two formulas working together...Maybe I am over thinking it. I need a formula to look at a "date1" column and a "date2" column on a sheet and then I need it to count the number of times the difference between those two dates is more…
sumifs function combined with NOT
Hi I try to set up a formula the first part is working. But now I try to exclude the not briefed articles in column (active article check). What needs to be adjusted that below formula is working? Thanks =SUMIFS([shipped quantities in pairs]@row, [Article#]@row, CONTAINS([Article#]@row, @cell, [active article check]@row,…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Multiple Criteria Formula - Metric Sheet
I am looking for a formula to calculate the number of APPROVED projects with Technology Impact. I am able to get the number of all projects with technology impact, but cannot figure out the second part of the formula to only include APPROVED projects. Current formula which includes information from the Technology Impacted…
Data reference from one sheet to another Formula not working
Hello community, I was trying to reference some data from one sheet to another via formula but it doesn't seem to work error in cell: " #unparseable" , here a breakdown of my goal and the formula I am trying to use: have 2 separate sheets, in the main one named request for information where people will submit their request…
Basic Cross Sheet Reference Not Working
I am trying to create a very simple formula to count the number of rows in a sheet based on status type. I'm getting an "unparseable" error and I can't figure out why. I've tried both the below criteria and "Intake" and am receiving the same result. Any ideas on what might be broken here??

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags