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.

Download Column Names & Column Types
We are making a master sheet to combine all of our 15 intake forms and sheets to help track metrics and more easily send intake rows/projects amongst teams once their portion of the project is complete and/or work on a project simultaneously. Is there a way to only view the columns for each sheet and their column…
Projecting Project Burn Across Different Dates and Durations
I've looked at several examples but can't find something that helps me close enough with this item. I'm brining in budgets from another sheet, same with the Start, End and Duration for each task appropriately. I'd like to project the total burn for each month associated with the project, but only for the portion of the…
INDEX/MATCH works in one sheet, same formula gives #INVALID OPERATION in another
Hi all I have a Project Info section of my schedule sheet that I pull into columns so that the info can be used in automated emails about tasks. The sheet that's giving me problems is a copy of another sheet, where the formula works. =INDEX([Task Description]:[Task Description], MATCH("Portfolio", Task:Task, 0)) It works…
Trying to gather cell info from 2 different unique id's on different sheets
The following sheets in my description are in 3 different workspaces if that makes a difference. We also do not have the licensing for control center if that is an easier solution, so im working with what Ive got. I have a sheet called "Project Intake" where most projects source from. There is an auto number column called…
creating a formula to flag a cell if 4 criteria match (two of which are dates)
I am looking to flag (during install) if the Ship & Venue Match a reference sheet as well as the Inc. Sign on Date is between the Start and End dates of reference sheet Formula page Reference page I feel like I am going to need to use =IF but also an =AND formula but I can't find the right sequence
Why am I not getting the same average value in my formula compared to the sheet?
My formula shows average of .3625 (rounding up won't even help) The sheet shows average of .97 (which is correct). The values outlined in blue are MS
Is there a way to automatic indent rows by number? in my case with level column?
Number of working days between dates and if blank number of days through today
Hello, I need help expanding this formula. Currently using IFERROR to calculate the range between columns Project Request Date and Project End Date, if the Project End Date is blank it returns blank; What I would like to happen is the same calculation BUT if the Project End Date is blank (because project is in progress) it…
How to add a new row using Index/Match
Hi - I am using Index/Match to align a project intake sheet with a project scope sheet so that the same information (Project ID, Project, Project Description) show up on the scope sheet from the intake sheet. My primary is Project on both and I have the cell linked from the intake sheet to the scope sheet and then I am…
Stop autoformat to a percent
Hello, I have a form that collects information on a person's effort on a certain project. The field is left open & not restricted to a certain value as it depend on the person/project what is best to enter. The issue is that Smartsheet takes some of the values & multiples by 100 so that I get 100% to 500% showing often,…

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

Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…
Formula help needed - if/then
Is there a way to make my formula (below) that if the "type of CPG" says "priority" in it that it can be - 21 days and all other types would be - 14 days? hopefully that makes sense!
Help with COUNTIFS, two criteria from the same column
I am being dim I am sure, I need to count some information that has been imported from an excel spreadsheet which is a download from our membership database so the formating is odd. This will be a regular download and upload so I don't want to spend time tidying things up so hive mind. This below works fine but I also need…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags