Adding a "Select-Case" Style Function for Easier Multi-Condition Handling

I’d like to request a new formula feature that allows users to evaluate multiple conditions more cleanly — similar to the Select-Case structure that I had found in a programming language.

Currently, we rely on nested IF() functions to test multiple conditions. While this works, it becomes extremely difficult to manage when the condition being tested is long or complex. Because we need to repeat the same condition multiple times just to check different cases, which increases the formula length unnecessarily and affects performance.

I am giving below an example of it:

=SelectCase(Sum([Amount]:[Amount]),<0, "Negative",=0,"Nil",>=500,"Good",>=1000,"Excellent")

The above function should allow testing as many conditions as Smartsheet's mechanism can accommodate. I'm sure this will help everyone a lot!

@Genevieve P.

Thanks

Sign in to vote!

Find more posts tagged with

Formulas

functionality

Idea Submitted

Comments

There are no comments yet

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Editable email Subject header from Smartsheet Notification
Hi There, I would like to propose that Smartsheet considers the email subject header that is received from a Smartsheet notification from a form or sheet. Currently, because not everyone in my company has Smartsheet, let alone a Smartsheet log-in, we need to send show the name of the owner of the sheet, that appears on the…