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.

Formula
Hi all, I am trying to combine the following two formulas, only one works at a time. =IF([Variance (Target End date)]@row = 0, "Green", IF([Variance (Target End date)]@row <= -4, "Red", IF(OR([Variance (Target End date)]@row = -1, [Variance (Target End date)]@row = -2, [Variance (Target End date)]@row = -3), "Yellow",…
IF(ISDATE) not working?
I have "Column B" that pulls in a date from another sheet. And I have "Column A" that changes to Complete when that date populates into Column B. In addition, I have a criteria for which it should say "Eligible", "Not Yet Eligible", or "Missed". This formula has been working just fine for a while. I have been updating a…
WEEKNUMBER formula
Hello, I am trying to count the number of weeks between two dates. I have applied this formula =WEEKNUMBER([SD End]@row - WEEKNUMBER([SD Start]@row)) It doesn't seem to be calculating correctly. For example, returning "51" for a SD End date 2/3/23 - SD Start 11/14/22. That answer should be more like 11, right? What am I…
Need help with Countif date formula
I have a date column, and I want to count the number of "Good Rolls" for that specific date. I managed to get Shift LBS Produced for the 24th and Total Rolls. The number 81 in good rolls column reflects the total for all date. How do I get a result for just the 24th, 25th etc.
Percentage Formula Troubleshooting
I am trying to set up a formula to keep track of our events, of which 50% need to be completed within disadvantaged communities. I set up a formula but its not reporting properly. Currently it should be 100% as we have completed two events and both were in disadvantaged communities. What am I doing wrong? Thank you for…
Stocklist
Hallo i am looking for a tool to create a list into smartsheet where we can see the QTY of goods inside warehouse. Via Forms i can make a scanningtool … which we do for 1 particulare client with al the same products. This works , today we have an other type of client in the warehouse with 5 different products. So i want to…
Formula Error at 100% Completion: How to Display 'Closed' Instead?
This discussion was created from comments split from: Automatic Project Phase Formula.
How to remove the apostrophe in front of a number on data imported from Excel
I have a column with Rank values on a sheet with data imported from Excel. The rank value includes an apostrophe in front of the number. What is the specific formula I need to use based on the example below? I've been trying to play with the examples given and keep getting errors. Thanks.
Formula Help
If I want to compare column 2 of Sheet D to column 2 in Sheet F, and return the value from column 1 in Sheet F to column 1 in Sheet D if 2D and 2F are equal, and not return anything if they are not equal, how would I put that in a formula? I think it's a vlookup but my formula didn't work.
CHAR(10) not adding internal break
Hi, There's probably a simple answer but when I use CHAR(10) in a cell formula in a form, it results in a space (probably a non printable character) instead of a break. The formula I am using is: =JOIN(COLLECT(Column1:Column1, Column2:Column2, "Responsible"), CHAR(10)) Even if I use: ="Apples" + CHAR(10) + "Oranges" I just…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…
Question about copying a sheet
I use Smartsheet to track my yearly activities. I have a sheet that is connected to this sheet for calculations that feeds into a dashboard. Hopefully that makes sense. My question is, I want to copy this entire thing and start new for 2025, however when I copy, the calculation sheet is still pulling from the 2024 sheet.…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags