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.

Harvey Ball status based on due date
Greetings Hope everyone is doing well. I have a need for some guidance. I've used a similar formula in the past but I am having issues with this one. What am I trying to do: I have a status column and RTDD date column and Symbol column for the Harvey Balls (red, yellow, green, and gray) I'm looking to have the balls color…
Added 2 years to date, only want to populate in specific fields
I have created a calculation to add 2 years to a specific date listed in a field, but I would like to create a formula where it calculates the 2 year date but only populates if the other field is filled in. Current formula: =DATE(YEAR([PO Date]@row ) + 2, MONTH([PO Date]@row ), DAY([PO Date]@row )) If the PO date is fill…
Fx decimal place output is too much
How do I correct the formula below to show only 2 decimal places? =IF([Total (Current) Annual Cost $]@row - [Total (Proposed) Annual Cost $]@row < 0, "(", "") + "$" + ABS([Total (Current) Annual Cost $]@row - [Total (Proposed) Annual Cost $]@row ) + IF([Total (Current) Annual Cost $]@row - [Total (Proposed) Annual Cost…
JOIN/COLLECT - Order by most recent
I’ve configured a Smartsheet process—fed by Data Shuttle—that supports multiple activity rows per consumer. Each row calculates a unique Row ID and helper flags (Occurrences, Duplicate Entry, Duplicate IDs) and builds a Detail Key that concatenates Item, Supply Count, Date, and Person. Using these helpers, the sheet joins…
Creating data to populate a dashboard
Hi all, I want to display a count of a particular item from 1 column (dropdown with multiple options) but need it to also cross reference another column (dropdown with multiple options). So example is if first column (Site) is "Preston" and second column (Contact) is "Warehouse" then give me a count of this combination.…
How do you create YTD formulas to track sums during a specific period?
I am having trouble creating a YTD formula to sum the total grants awarded for a given period. Any guidance would be appreciated. Thank you
Dashboards for comparisons from year to year
I am trying to write a formula that will compare two sheets of data, one is last year and one the current year. I want to know what items where received last year on this date and it run/update daily. If that makes sense.
Sum(Children()) Formula Issue
My sum(children()) formula in the first row is resulting into zero. Idk why although I tried to double check that the numbers are formatted correctly. any assistance is appreciated.
COUNTIFS & ISDATE FORMULA
Good Afternoon, Hope you are safe in this winter weather. MY FORMULA is unparseable: =COUNTIFS([DEACTIVATE TIMESTAMP YR 5]:[DEACTIVATE TIMESTAMP YR 5], ISDATE(@cell ), [Abbreviated Org Name.]:[Abbreviated Org Name.], "CHARM")) The formula should count ONLY if any date is appears in column DEACTIVATE TIMESTAMP YR 5 = ANY…
Can you make a dropdown option dependent upon another drop down? Parent / child
Hi, I am trying to setup 2 drop downs in a grid sheet. The user will select from the first dropdown (parent) A, B, C and based upon what they select i only want to show the corresponding options in the second dropdown (child). So for A show 1, 2, or 3 For B show 4, 5, or 6 For C show 7, 8, or 9 . Using a form is not an…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Upcoming Events

Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

RYG Formula based on Due Date and Percentage complete
I am struggling to create a formula for the RYG symbols. I would like to base it off percentage complete and due date. What I am looking for is: Red = Due date <2 days less than .90 and anything past due Yellow = Due date < 4 days less than .50 All other green
# of occurrences formula
I want to show how many times in the past six months that a supplier has had a complaint issued against them. This is the formula I am using but it returns all zero's. =IF(Supplier@row = "", "", COUNTIFS(Supplier:Supplier, Supplier@row, [Date Submitted (Created Date)]:[Date Submitted (Created Date)], ">=" + TODAY(-180)))…
Match / Sumifs formula
Hello! I am looking for a formula to match the entry in sheet 1 to the entry in a sheet 2, then sum a column in another sheet 2. Would a match or vlookup formula work best? 1 - Match Primary, Tower and Blade columns in sheet 1 to Site Name, Turbine Number and Blade Number Sheet 2 2) Return sum in Travel Hours column from…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags