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
Pull Items from another sheet set for earliest date
I'm fairly new to SmartSheets and have been trying to figure out how I can pull items from my master list to show what is set for the next launch. Here is an example of my master table I want the new sheet to capture a different row for every enhancement in the example it would grab. A,C and E. Any help would be greatly…
Smartsheet Link Cell Error
Hi, I'm trying to link two items from two different columns on one Smartsheet from another. I essentially have one project plan which only shows that project and another summarizing all different project plans and I'm trying to link the beginning and the end dates from the single-project plan into the summary sheet. The…
Auto Image Insert
Hello I've been trying to find a way to have an image in a cell which then shows up on an update request. I have a cell where the reviewer needs to choose an option but I want to give them a reference table. I've added a helper column in which I can manually insert a simple image to help the reviewer see the reference…
Dates in AVERAGEIF Formula
Hello all! I need to use formula averageif to count average of duration of projects in weeks, it is bases on the end date of it. I try to do it in Summary of the sheet. Here is the formula but id doesn't work. =AVERAGEIF([End Date:End Date], [End Date]@row<DATE(2019,12,31), Weeks:Weeks) It shows that this formula is an…
sum( not working
Hi All I have been using sum( on tables like this - had no problem until today when building a new table for October and sum will just not add up my columns - it has done so in previous tables ( have a double system going to make sure counts are correct) But i just cannot get it to work - have tried deleting the cells and…
Please Help!
I'm creating a CRM, I have 2 columns. One is the Sales stage with column properties (drop-down list) and the other is a probability% column with drop-down options. I want a formula that will add the percentage from the drop-down options based on the sales stage that's selected. Example if '1. Not Qualified' is chosen, I…
Counting criteria and blanks
How would this be modified this to allow for counting both yes and blanks? =COUNTIFS({Operation}, [Column2]@row, {Assigned}, "Yes")
index/match
sheet 1 has a name i am looking for i have 2 sheets (only has part of it) i need to past in sheet one the age. i have tryied using it Index/Match, but it only looks for exact match. i have tries using collect, and/or contains and could not do it. can someone help my in string to pull data from sheet 2 if i only have…
How to create the formula for a workflow and automation
How to create the formula for a workflow and automation to monitor and execute a task on a birthday listing on an annual basis? Million Thanks in Advance.
Counting in a Multi-Select Cell While Having Additionally Criteria
Hello - I am having issues figuring out the correct formula to use when counting criteria in a multi-select cell while also capturing a specific criteria. Please see below my example. The sheet I have below is derived from a Form. Within that form, individuals who submitted a response had the option to select a Sport with…
Help Article Resources
Trending in Formulas and Functions
Need to find all instances of value and return any non-blank cell from another sheet?
Hello Everyone, I'm stumped and need some assistance. What I am trying to do is look for the value in the Cable Number column (Cable Number]@row) on the master sheet in the Cable Number Column on the Update Tracker (Update Tracker Cable}). There will be multiple times this value is in this column but some dates will be…
Hello I am trying to create a formula that returns a specific date when a dropdown selection is made
class requested start date Jan 13, 2025 - July 14, 2025 Oconomowoc, WI Jan 13, 2025 - July 11, 2025 Huntsville, AL (new site) Feb 10, 2025 - Aug 11, 2025 Amsterdam, NY Mar 24, 2025 - Sept 22, 2025 Fontana, CA Apr 21, 2025 - Oct 20, 2025 Oconomowoc, WI May 13, 2025 - Nov 17, 2025 Huntsville, AL Jun 16, 2025 - Dec 15, 2025…
How Do I add Sum(Children) at the bottom of the children rows
Hi, How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom. I usually create a parent row, then add rows beneath it, indent them and add the formula =Sum(Children) to the parent row to calculate the total. However, that structure was confusing for users, and they…