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.

Extract the text to the left of the rightmost character in the column
I need to extract the text to the left of a hyphen in a column, but some entries have two hyphens (actually it's a hyphen plus a space, but I'm sure I can figure that part out.) so it has to be the text to the left of the rightmost hyphen in the cell. I poked around the help forum then asked the AI formula generator. It…
Value Labels disappear on my chart Widget
When in edit mode, I choose to show value lables and looks fine. However, after I save the change, some of the values disappear. Is this a bug, or is there a setting I need to update?
Creating formulars and automating payment terms with regard to cash flow amount and month of payment
I need to create a Smartsheet that allows me to manage different payment terms for specific monthly payments. This sheet should enable me to manually record payments in a designated month column and automatically capture the payment terms in another column, reflecting the month the payment will be made and the exact…
TODAY() not updating till the file is opened
We have using TODAY() functionality since 2018-2019 with no issues, why is this issue coming up now? We have opened ticket and I have been told to implement a workaround that according to the feedback in this community is not a full proof workaround. Here is the ticket number: 08096290: Schedules only refresh when the…
How to show only fields completed on the emailed copy of the form?
Hello! New SS user here. I have created an order form for our internal marketing team and I only want the fields completed to show up on the email of the completed form with any items they attach to the form. See my screen shot below. This shows the only item wanted is a TRIFOLD (which was one of the drop down items). My…
How to use "OR" when having several IF statements
Hi, I posted a question earlier today so this is similar but maybe a different way of going about the solution I'm looking for. I am trying to figure out how to use "OR" when having 3+ actions in a single formula based on if a field is blank or not. My scenario is this: ORG Code 1 Object Code 1a Object Code 1b Object Code…
Subtract 2 Cells
I am feeling completely inadequate, lol! Just trying to simply subtract one cell from another. I have tried various ways. This is one way: =[FY26 Member Fee]@row - [[FY 25 Member Fee]@row] Please help! Thank you
Ignoring Blank Dates
I have a sheet that is checking for past due dates. This formula works to add a check mark when the task is completed on time: =IF([Task Closed Date]@row <= [Due Date]@row, 1, 0) But it counts the blank dates in "Task Closed Date". I have tried mimicking other formulas that utilize ISBLANK, but none of them have worked.
Averaging
Hello, I'm trying to get the overall average for the percentages in top row highlighted in purple for that month. What is the formula that I would use?
Stop Formula reference from applying to whole column/sheet
Hello, I have a formula I am trying to apply to only certain cells. See below: =IF(ISNUMBER([Column15]@row), IF([Column15]@row >= {LL5}, "5", IF([Column15]@row >= {LL4}, "4", IF([Column15]@row >= {LL3}, "3", IF([Column15]@row >= {LL2}, "2", "1")))), " ") Then I want to copy and paste this formula to a different cell on the…

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

Sum values based on corresponding value in second column
Hello, I am working on a project aiming to calculate the remaining product cost for a list of contracts. I have two columns with data which both have multiple values separated by delimiters and need to add the values in column 1 (quantity shipped) if they match with a specific value from column 2 (dosage). Example Data:…
Convert a Sum into Currency format $#,##.00
I have a formula that creates a note and within that note is a sum of numbers. For example, JOIN("This is your total: $" + round(sum([Number1]@row, [Number2]@row), 2)) When I use this formula, the results look like "This is your total: $34000.00" when I need it to return "This is your total: $34,000.00". When I use…
Hi, trying to figure out how populate one cell if range of other cells contain certain text
Want to enter text in the Late column row 71 if in the Status column rows 72-84 contain the text "Late" …. Thoughts Thank you in advance Dave

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags