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.

Index Match not working
Hello - I am trying to use a formula on sheet 1 to return a value from sheet 2 based on the matching of a task name. I have tried the below formula (in many adjusted forms) but cannot seem to get it to work correctly. Some troubleshooting I have done: Set up references to search the entire columns of "Task Name" and…
Wanting to add a range of cells within a column using conditional formatting
Is it possible to use conditional formatting to sum up cells to use on metric sheet for dash? Or is it a sumifs formula? Or another sum formula. Or is it some report that I need? Thank you
Creating Expiration dates based on products
I want to create a formula that will auto-generate expiration dates for individual products for an entire column. The sheet has a created date and column containing a dropdown list of products. The products have different expiration dates. Ideally I would like to format the expiration date column to have the product…
Help please
I have a column that keeps returning errors….causing quite a bit of confusion and frustration. The first threat formula is working as intended. First milestone threat formula: =IF(AND([Percent complete]@row <> 0.1, TODAY() > [Currentmilestone date]@row +14),"Red", IF(AND([Percent complete]@row < 0.1, TODAY() >…
Why does my 'Copy rows' automated workflow ignore conditions?
Hi All, I'm starting out with Smartsheets and trying to set up a basic workflow to copy rows into another sheet based on whether a checkmark field is checked. Please see below my current setup. Having both tested or run the workflow, however, all the rows are being copied, not only the ones meeting the 'checked' condition.…
What formula do I use to determine a value from multiple rows?
I have 6 centers. Each center has its own row and a status of On Track, Off Track, or High Risk. If all centers are On Track, the organization is On Track If one center is Off Track or High Risk, the whole organization is Off Track or High Risk. I need a way to change the status in a separate column if any of the six…
How do I count days between 2 dates but break them out by month. For example. 9/30-10/1. This is a c
How do I count days between 2 dates but break them out by month. For example. 9/30-10/1. This is a count of 2 days but i want to capture it as 1 day in October and 1 day on September
VLOOKUP or IF(ISBLANK) formula?
I am trying to find a formula that will pull the information from the Building and reception level columns onto another sheet based on if the Assigned Receptionist column is blank. I'm not sure if this would be a VLOOKUP or an IF formula. Is this sort of function possible? Thanks for the assistance!
?Vlookup?
Trying to create a Grid to help me identify deltas from 2 other grids. First Grid is called "Forecast", second grid is called "Actual" Column A on both Grids is Account Name Column B on both Grids is Quantity In my NEW Grid called Delta - I would like to be able to compare the quantiles from column B and match them to…
Formula to Set a field if something blank
Hi, I'm looking for advice on how to track what my original end date was and then what it ended up being at completion. I have a cell called End Date With Stabilization. That adjusts all the time as we push out closing a project. I want to track what it was first set to comparing what it ended up being at project closing…

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

Question about copying a sheet
I use Smartsheet to track my yearly activities. I have a sheet that is connected to this sheet for calculations that feeds into a dashboard. Hopefully that makes sense. My question is, I want to copy this entire thing and start new for 2025, however when I copy, the calculation sheet is still pulling from the 2024 sheet.…
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags