Does Smartsheets have a CASE Statement function?

Options

cro1

cro1 ✭

01/23/24 in Formulas and Functions

Does Smartsheets have CASE statements? Or am i forced to use nested IF's?

Tags:

Formulas

0 ·

Answers

Paul Newcome Community Champion

01/23/24

You will need to use nested IFs.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
1 · Share on Facebook Share on Twitter

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

Trying to return 3 months prior to Date Column
Hello, I am trying to make a column to return dates 3 month before the date in another column. Essentially going to be notifying teams 3 months before something expires. I have a column for the dates. It is set to "date" and i'm using this formula in a helper column =DATE(YEAR(DATE@row ), MONTH(DATE@row ) - 3, DAY(DATE@row…
Move data from a column into a cell
I would like to pull the name that is listed in the Name column into the Primary Column. Note that the name could be listed multiple times in the Name Column.
Heat Index calculations
Hey Smartsheet friends I have one of "those" formulas i need to use in a calculation that uses quite a deep decimal placement. For those of your that are a bit geeky like me you will love this one!!!! I am collected information on temperature and relative humidity and I need to calculate the heat index (it's part of a new…