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.
Discussion List
Formula Help with Parent Function
I need help creating a formula that references the name of the first parent row. There are multiple parents and I want the "closest" parent name to populate in the Test column. Hierarchy Level is showing what I want to populate but has been added manually. All the brown and white headers below Module 1 Overview should have…
Ignoring Blank Rows in a List
Hello, Trying to figure out how to display results in a cell that will ignore blank rows. I have a cell that lists results in the following manner: Site 1 Site 2 Site 4 Site 5 Site 7 Is there a way to list the results without the blank rows between site 2 and 4 and between site 5 and 7? cell formula: =[Helper Site 1…
Multiple IF Statement Returning Different Text
Hi Everyone, I am trying to write a formula that will look at a cell and if certain wording is not in the cell then return a value to a new cell. The information is from a multiple dropdown selection column. Here is an example of what i am trying to do. Dropdown List Would Populate the Missing Color column based on a…
Help with Index/Match & Column Formulas
Hello, I am trying to create an index/match function but am receiving a #NO MATCH even though I know the value is in the reference range and I am almost positive my formula is correct. The problem might be that I am referencing a range in the 'match' section that is a column formula. Does anyone know if this is the problem…
Why doesn't the date format change for certain columns?
Hi, I am trying to change the date format (to 01-Jan-2024) of 4 columns. I could apply the change to 3 columns, but not the forth one ("Project Sheet end date"). The cells are linked to a sheet and the date format is also 01-Jan-2024 in the source sheet. Why isn't the format being applied to the forth column?
How to Add Categories in Personal Budget Management Template
Hello. I am new-ish to SmartSheet. I am wondering if anyone can help me understand how to add more budget categories to the existing Personal Budget Management project template (specifically trying to add categories to the "Budget Setup" sheet in a way that keeps the formulas in tact... currently only a certain number of…
What is responsible for these seemingly uncaused cell changes?
I have a smartsheet mystery on my hands. A few people have looked at it and are now just as confused as I am, so maybe someone here has at least seen this before. One of our cells, a very important cell on several provisioned projects, has been changing despite the cells that it is based on remaining static. Allow me to…
Formula - I am Stumped
Good afternoon I am not understanding why I am having this issue, I have two sheets and on one sheet thecolumn formula works, on the other sheet it is giving me an "Invalid Ref" . For what is is worth the formula is =SUMIFS({BESDailyReportandWorkHrSheet2023_HRSTODAY}, {BESDailyReportandWorkhrSheet2023_Scope}, Scope@row) +…
What formula to show if Green, In Progress
Hello, Looking to create a formula to return the below data. If Blue=Completed, yellow=not started, red=at risk, green=in progress. Thanks!
Multiple Filters in a Column
I have a column for State where work is being done in. I need to set up a separate filter for West, Central, and East Regions with their perspective states. Does anyone have an idea on how to achieve this? I'm not seeing anything for any comma separators anywhere.
Help Article Resources
Trending in Formulas and Functions