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.

Append cell value with previous value and new value from another cell
How do we append cell value with existing data.? for example. column source and target. target = target + source. so every value entered in source it should be appended to target with already existing value in target. any idea or formula , please help. thanks
How to use predecessors to auto update Part Numbers?
For my use case, I have a version of a product that only updates when it changes on the next version. So for example say I have an assembly that has 3 parts in it. Lets say V1 and V2 of this assembly are identical except 1 item is different so has a different number: V1: 001 [Input] 002 [Input] 003 [Input] V2: 001…
How can I ignore a blank cell in an IF formula?
I'm calculating the workdays between two days and updating the status in a different column. How do I make the formula ignore blank cells in the Install Difference column? =IF([Install Difference]@row >= 21, "Late Over 4 Weeks", IF([Install Difference]@row >= 11, "Late Over 2 Weeks", IF([Install Difference]@row >= 2,…
How to auto populate metrics sheet?
Hello, i'm looking for help to auto populate a Metrics sheet with data from an Intake Form that would provide average values arranged by Vendor/ Quarter/ Year?
Overall Health based on not completed tasks
I am looking to update this formula I currently use in the parent of the Health column. It currently looks at child rows below and returns the color of the most "severe" status. (if it find any red, it returns red) What I need: However, if the phase is completed and the rest of the tasks are on track, I don't want to…
Health Formula
Hello, I am trying to apply a health formula to a project plan and getting a blocked and incorrect Argument Set. Any ideas for why? Formula is below: =IF(Children@row = 0, IF(Status@row = "Complete", "Green", IF(OR(AND(ISDATE(Finish@row), Finish@row < TODAY(), Status@row = "On Hold", [At Risk]@row = true), "Red",…
Weird Formula Help
I have the following columns in my sheet: Is This An Object? (a drop down "Yes" or "No" column) Object # Box # Folder # HW ID I need a formula for the HW ID column that mirrors the "Object #" IF the "Is This An Object?" cell is "Yes". However, IF the "Is This An Object?" cell is "No", then I want the HW ID column to…
Vlookup - #unparseable result
I built a tracker that is populated with an intake form. One of the criteria is a broker code, that when entered on the tracker from the form, is vlookup’d from a reference sheet and gives me the broker’s name, their branch code and branch name. This works perfectly fine for our purpose. Our team has now been tasked with…
How do I bundle tow categories into one?
I am trying to track revenue that is open and revenue that has been won together through an intake form. It is currently showing all of it together but I want to be able to track open revenue through open cases and how much has been one. I need an equation for this. I also need to bundle other categories like this : AOV…
Round Robin/Cue Function?
Hello, I'm looking to incorporate a simple round robin feature, i.e.: Column Header Titles: C1) Unique ID C2)A C3)B C4)C Step 1) Person S uses simple form that only requires Person S to enter a unique ID - the person enters that and saves it Step 2)That information entered would be saved to column C1. Step 3) That…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Need to highlight if two numbers in two different columns match
I have a number of days column called "Adjusted Duration" (it is calculated from two other columns) and then I have a helper column called "Days" that is a number that is converted from the System Duration column into a number using this formula (=Duration@row). I need to compare these two numbers (Adjusted and Days) and…
Formula in Smartsheet that will tell me if the data in 4 different columns is the same
I am looking for a formula in smartsheet that will tell me if the data in 4 different columns is the same. In excel I am able to use =COUNTIF(A3:D3,A3)=4 In Smartsheet I am getting "INVALID COUMN VALUE"
Formula to summarize data from symbols column for same row ID
This discussion was created from comments split from: Countifs formula with and/or criteria across multiple columns.

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags