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.

Is there a way to find and highlight a combination of cells that sums to a specified amount?
I have a sheet with $ to be paid that a vendor uses to issue quarterly checks, but the check doesn't match the total on the sheet. Is there a way to solve which lines are being paid with the check? Thinking of a formula that would highlight the combination of cells that add up to a specified amount (in this case,…
How do I get my datasheet to show the months requests were opened and closed
when my request tracker sheet's input is in calendar format? Current set up is as below, and I'd only like to use data from column A & B to ensure better accuracy in the data sheet:
How can I create an autonumber field that only increases when the column "Hierarchy" = 0?
What I have tried so far but is not working: =IF([Hierarchy] = 0, MAX((IF([@[Hierarchy]] = 0, [@[AutoNumber]]))) + 1, "") =IF([Hierarchy]@row = 0, COUNTIFS([Hierarchy]:[Hierarchy], 0, ROW([Hierarchy])@row , "<=" & ROW()), "") =IF([Hierarchy@row ] = 0, COUNTA([Hierarchy@row ]) + 1, "")
Summary Sheet Formula - conditions
Hi Wizards, I use a lot of formula including summary sheet formula for use in dashboards. SUMIF and CountIF are great but here is my problem (bear with the long explanation) 3 departments fill in a daily form and select Area (Stoke, CC or Transport) and then provide 4 or 5 pieces of information all through a form. This…
How can I calculate and display a percentage ratio between two numeric columns in Smartsheet formula
I have a Smartsheet with two text/number-type columns: Credit Consolidated Credit Required by Proposal I’d like to add a third column (Formula type) that divides Credit Consolidated by Credit Required by Proposal and shows the result as a percentage string (e.g. 130%). Smartsheet doesn’t offer native percentage formatting…
A cross reference formula that was working before suddenly stopped working
I maintain a weekly project tracking system across two sheets: Sheet 1 (Project Status): Contains detailed project status updates Adds 20 new rows each week (one per project) Includes a 'Snapshot Date' column to identify the week Sheet 2 (Status Summary): Tracks project status counts (on-track/off-track) by week Previously…
Looking Up Value Based on Date Range that a Date Falls In
Hi I'm looking to create a lookup that uses a date field (pub date) and then pulls a value called Selling Season based on the date range that pub date falls within. Current formula that isn't working: =INDEX(COLLECT({Selling Season}, {Pub Date Start}, [Pub Date]@row >= {Pub Date Start}, {Pub Date End}, [Pub Date]@row <=…
Help with formula
This discussion was created from comments split from: Extracting Data From Cell.
Is it possible to connect Sypro to Smartsheet?
Our client wants to connect Sypro to Smartsheet so they can only have 1 reference without duplicating/transferring the information from Sypro to keep from doubling the effort.
Formula Help: Sumifs, based on multiple values and excluding one value
I'm struggling with my Sumifs formula, where I want to return a sum value based on two conditions and a further third condition that excludes a certain condition. I can get the first bit working, but I'm struggling to exclude the status 'Cancelled' from the calculation. Can anyone help advise where I'm going wrong please?…

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

Total Project Count FY2025
Hello, I am looking to count all projects that have "gone-live" FY2025. In my grid, there is a column titled "go-live" that lists the date a project went live. Is there a formula that can calculate FY?
Extract Number from Cell that Begins with Text
I need to extract all of the numbers from a column and move them to a column on their own. These cells begin with text. The data is not always the same length. This is a sample of the data. Can you help me with a formula that will extract the varying accounts below 45811050-45811050-77510, 45811050-4581-13120.009,…
Index/Match formula using a range of values?
Hello, I'd like to create a formula or series of formulas to accomplish the following… There are two sheets: Source Sheet Return Sheet Source Sheet: Return Sheet: What I'd like to happen is… on the Return Sheet: When a value is entered in the Constituent Number column, the sheet returns a corresponding value in…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags