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
Counting Number of Requests completed Last Week by Type
I have a metric sheet that I am using to generate a dashboard. One of the metrics I'm trying to get is the number of Requests completed last week based on the Type of Request A B C. I have a column for Date completed and a column for Type. This formula works to get provide the count of all Requests closed last week.…
Automations No Longer Triggering
We have multiple automations that were previously working that are no longer triggering and I can't figure out why. Here's one example: It was last triggered over 2 weeks ago but there are 53 rows that have an updated status meeting the criteria that have not moved over to the Archive sheet. Any idea what might cause this…
Sum of column values that come from function formula
I have created a formulation of a drop down with prices associated with each selection that population on a different column: =IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major…
Finding duplicate values in a column only on certain responses
Hello, I want to look for duplicates in a column but only on certain cell values in the column. In this case, any cell in the column that has the number 59 in it I want to be evaluated to see if there is a duplicate in the same column and then return a true to my check box column type. I can get this to work when I look…
Is there a formula for my parent row to always pull data from the most recent child row?
I have a parent row that I am using the generate a summary of the most recent child row. My team will need to enter rows and in the children section to add their updates and I want to parent row to automatically capture the most recent notes of the child row. Is there a formula to do this?
SUMIFS Formula Assistance
I have a sheet in which I want to SUM a column of data if the status is equal to a value and the year is equal to 2023. It seems to not like my year criteria =SUMIFS([SaaS Value]:[SaaS Value], Status:Status, "Active", Year:Year, "2023") Specifically I am getting an invalid data type error
Copy Target Date into a Locked Column on the Same Sheet
Hello! I need to automatically copy over the target due date when initially entered into another column that is locked so that employees cannot change the initial target due date they entered. Is this possible in Smartsheet?
How to ignore (0.00) when using SMALL Formula
I have 3 columns and each row I would like to return the smallest number. If one of the three columns contains a zero then I would like to return the NEXT smallest - essentially ignore the zero (0.00). How do I accomplish this?
Formula that updates % Complete based on Status
I need a formula that updates the "Percent Complete" column based on the "Crossing Agreement Status" column. Owner Not Identified = 0% Owner Identified = 25% Owner Contacted = 50% Owner Deferred = 50% Agreement in Negotiations = 75% Agreement Executed = 100% Example: If the crossing agreement status is marked as owner…
Countifs formula for distinct values
Hi! I need a formula that counts rows based on multiple criteria but only provides one response per duplicated value. For Example I want a countif formula to pull one number that looks at if "Owner Name" = "Amtrack" and "Crossing Agreement Status" = "Owner Contacted" to provide only one number, but note that there are 5…
Help Article Resources
Trending in Formulas and Functions