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
Dates in IFS Statement
I am trying to use dates (formatted in dates columns) in an IFS statement to compare dates in multiple columns and provide calculations based upon whether a date is before or after (<>) a certain date. I am getting an #UNPARSEABLE error message. I'm wondering if the dates are not reading correctly in the formula, or if…
Can i populate data referring to multi select drop down(as a primary key)?
i have a column with multi select drop down option, i need to populate the data from another sheet referring to the drop downs select. How can i refer the first column as primary key to populate the rest of the data. My primary key would be the multiple dropdowns selected.
Dashboard question- Can I add a list of locations to click on and all of the widgets update?
Like in excel pivot tables, how you can add a 'slicer' and then all of the pivot tables you've connected to it- will update their data based on the item you filter/click on.
(Count if) And & Or
I need a formula that will count the number of rows with High priority and are New OR Open. I cannot figure this out, so any help is appreciated!
Nested OR function within and AND logical statement
Hello, I am trying to have the following into a single logic statement: IF Nucleotide Category is "Labeled" AND Characterization Status is "Characterized" AND QC Status is either "Pending" OR "Incomplete" =IF(AND(Nucleotide Category]@row = "labeled", [Characterization Status]@row="Characterized", (OR([QC…
When move/copying rows, how to prevent new columns being added in the destination sheet.
In Smartsheet's article, it's stated that "If the source sheet contains columns that the destination sheet does not, these columns will be created in the destination sheet when the row is moved or copied." Is there anyway to prevent this from happening? i.e only information in matching columns will be moved to the…
Countifs and check boxes.
Good Day, I keep receiving unparseable/ errors for this formula. I've typed this 20 different ways. I'm very lost at this point. =IFERROR(COUNTIFS({Oil Change Tracking Range 1}, [Zone:]@row, {Oil Change Tracking Range 2}, [Service Date:]@row, ({Oil Change Tracking Range 4}, = 1))"") My end result is to check a box if these…
Date Validation
We're tracking Open Enrollment for multiple clients on one sheet (below just includes one client). I have played with helper columns trying to find a way compare these dates with no success. Since they are on different rows, getting them to line up to compare them is providing difficult. Any suggestions or tips would be…
Lookup formula still available?
Hi there! Is the Lookup formula still usable in Smartsheet? I'm trying to do a lookup within a matrix of values, where I need to specify both a horizontal and vertical lookup criteria. From what I've found, it looks like Lookup would've been able to do it, but it doesn't look like that formula exists in Smartsheet now.…
Is there a way to add/edit responses to a form without creating a new submission?
I'm wondering if there is a way to create a form that has a "save" button instead of "submit" so that the user can return at a later time to complete questions? I want to be able to use the form as a working document for a period of time prior to submission.
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…