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.

Combine IF formulas in one cell
Hello, I have the following table (below) with a column ''amount of per diem used'' and a column ''number of days abroad''. The total amount of per diem will depend on whether the 40% rate applies, or the 70% rate or the full amount. So, I would like to use a multiple formula in one cell that says: if the box 40% per diem…
Calaulate activity health based on % complete and Planned Finish date
In my sheet I have a column "% Complete" and "Planned FInish". Is it possible to create a formula which can highlight the row color in red, blue or green or yellow if % complete is less then 100% and planned finish is over a certain date (example 10 Dec 2024). I am new at smartsheet, need help from our community.
Can the auto-numbering function be set up to utilize new numbering prefix at start of each year?
I created a sheet that uses auto-numbering to assign a number to all submitted forms. I want the numbering to utilize a prefix denoting the year and start over at 0 each year. For example the numbering of the submissions in year 2021 will start with 2021-01 continuing with 2021-02, 2021-03, etc. When the year 2022 is…
How can I get horizontal tick marks in dashboard graphics to show?
Graphs have Horizontal Tick Marks but they only show when a graph is in edit mode (red arrows). They all have show tick marks checked for horizontal. The middle chart on the bottom is the one that is being edited. How can I get the tick marks to show when it's live?
Auto Number Formula Help - Add Project Code as Prefix
Hello, Is there a way to create an auto-number system to show [Project Code]-P-[AutoNum] where the auto number references the project code in the same row? Here's an example to illustrate: But when I try to add this prefix system to the Auto Number column properties… [Project Code]-P- types it literally… "[Project…
Counting quantities from another sheet that correspond with a reference on original sheet
Hi folks Really need siome guidance. I've tried the AI tool, but not getting anywhere. We are carrying out a network audit at multiple sites. I need to be able to display the SUM from another sheet when it meets the critera from current sheet: For example, I want to bable to display a summary of additiopnal switches needed…
Lookup the text of a predecessor by starting with the predecessor #?
Here is what I'm looking to do… If I flag a task as being late, I want to look at its predecessors to find the blockage. What is the easiest way to do that? I'm sure that I will need row numbers in this solution. Let's say I have that covered (I don't). Once I have that ready. I can look at the predecessor #, go to the…
How to extract just the month name from a date
Hi all, I'm trying to extract month name from the date column. It has been giving me an error. Any input will be highly appreciated.
Increasing number when meets same value autonumber, possible formula
Hi i badly need help! Is there any possible formula to achieve the output in SERIAL NUMBER column? By the way it is manually encoded. Thank you
Month over Month Variance w/ live data help.
Hi SS Community, I am trying to create Month over Month varience report for my project management work flow. I currently have a Smart Sheet and Sales Force integration that updates my data live 2 ways, and that's where my problem begins. Below is a screenshot of Project Status dashboard graph as of 10/28/24 . I'd like to…

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

I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags