Upcoming free webinar on 3/12: Introductions to Formulas!

[Deleted User]

[Deleted User] ✭✭✭

03/09/20 edited 05/31/20 in Formulas and Functions

Join us for an introduction to formulas. In this webinar, you will learn how to:

Reference cells and structure basic formulas
Summarize indented rows with unique Smartsheet formulas
Power metrics with cross-sheet formulas

Additionally, we will be hosting our Advanced Formulas webinar on 3/19!

Learn more and register HERE.

View upcoming webinars HERE.

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Can't get IF formula to work,
I have two columns with numbers, and one column with at checkbox, I want to use IF to automatically check the box if the cell in column 2 I bigger than the cell in column 1. This is my formula in the the checkbox column =IF([Column 2]@row<[Column 1]@row) 1, 0 But I keep getting the Unparseable message
Invalid Data Type Error
I have two formulas on different Grids doing the same thing. Formula 1 works, but formula 2 does not. I have double checked the data types of all references and they are the same in both formulas. ={T-Cost} * SUMIFS({T-Total}, {T-Date}, AND(MONTH(@cell) = $Month@row, YEAR(@cell) = [2024]$1)) ={Tourn - Cost} * SUMIFS({Tourn…
Percent formula for drop down fields
I have a column with the following options for drop down fields: NA, Not Started, Required, Drafted, Posted What formula can I use to show me % complete (posted) without taking into account the NAs?