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.

Formulas to link cells
With the recent expansion of formulas to cross reference other sheets I would love to be able to split projects to other sheets. If I could pull the Primary column and the Start Date column via formula I could have secondary sheets that have their own unique information. The new help sheet here, Referencing Data from Other…
Sumif for an month to day invoice amount with date criteria
I have an Invoice Smartsheet which has invoice amount for invoices for last several months. I have to calculate month to day invoice amount. I have given the following formula: SUMIF([Inv Amt Rs]:[Inv Amt Rs], [Inv Date]:[Inv Date] > "02/01/2018") This evaluates to zero, even though invoice amount is there in the range.…
Simple Subtraction Question - Cell Contains Formula
I have a hard keyed number in a cell (113), in cell to right is a formula =COUNTIF(Status3:Status97, OR(@cell = "Active", @cell = "Invited")), resulting in a count of 93. I am trying to subtract the 113 from 93, with result of 10 displayed. I know this is simple but I can't figure it out!
Do Cross-Sheet References Impact Sheet Load Time?
As my Smartsheet app has gotten more complex I often try to find ways to simplify sheets and speed things up. The new cross-sheet reference capability has me wondering if it would be faster than the existing links when loading a sheet? I don't know exactly what goes on when you load a sheet but the save icon stays dark…
Formula creates a String - Cell no longer blank/empty conditional formating
Hello, I have a particular problem, I have a series of cells that have formulas to detect the checked values of a series of Check Boxes, creating conditional formatting and inserting 'N/A' in certain cells: =IF([Assemblage Mecanique]8 = 1, "N/A", IF(Coupe8 = 1, "N/A", "")) after this check the cell retains a sting of…
COUNTIF example formulas using check box columns
Would anyone have a example of a formula to count checked boxes in a column divided by the number of unchecked boxes. Any help will be greatly appreciated. Thanks.
Formulas: Reference Data from Other Sheets
Good afternoon Smartsheet Community: I am trying to add the total from the count of 2 sheets given the criteria. However, I am receiving an INCORRECT ARGUMENT SET when using SUM or Count conditions (formula below). Any help appreciated, Thanks! =SUMIFS({A9: PayChex TLS Impact List Range 1}, "Need A File Build", {A2: ALL…
sum with new vlookup sheet reference
I have this formula copied down a column: =vlookup(A1,ReferenceAnotherSheet,3). The first row bring back the correct number value. The other rows are bringing back a #nomatch. Also, I want the cell to return the total of all cells in column 3 that contain the cell referenced in A1. I know I need to use sum or sumif, but…
IF/AND and cross-sheet reference
I'm trying to write an IF/AND statement that references a range of data in another Smartsheet but an #INVALID OPERATION message is returned. * IF the user is requesting to use the Immersive Learning Center * AND the user is requesting to schedule their event on a date when the Immersive Learning Center is closed…
Count number of unchecked boxes
To count the number of unchecked boxes I'm using the formula: =COUNTIF([% Complete]3:[% Complete]60, 0). The issue is that it is also counting blank rows. How do I get it to only count actual blank checkboxes?

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

Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
AND-OR-COUNTIF Question
Hi, I started to build a formula and it doesn't return the required values. I have a sheet for distribution board testing. There are 25 yellow checkbox columns and 24 green checkbox columns. I have a column with 4 colour symbol (L1-Quad), and a checkbox column (All DB Tested) where the formula needs to return the value. My…
Formula produces #CIRCULAR REFERENCE
I'd like to compare the dates in two rows, i.e. Ende (Plan) and Ende (nach Verschiebung). If Ende (Plan) is older than Ende (nach Verschiebung) the date should change to red colour (or somehow be highlighted). The AI tool in Smartsheet proposed the following formula =IF([Ende (Plan)]@row < [Ende (nach Verschiebung)]@row,…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags