Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Maximum Value for a cell

Victoria Ganuelas

Victoria Ganuelas ✭✭✭✭

01/10/17 edited 12/09/19 in Archived 2017 Posts

I have a column #3 that currently calculates based on column #1 and #2 however, I do not want the value of of Column 3 to exceed 150. What would be the formula for this?

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

01/10/17

Victoria,

=MIN(your current formula here, 150)

Craig

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Using Nested If and Formula to Set Value of Field
I'm trying to set the value of a field using an IF statement based upon a calculated number in a column called "Tier Score". =IF ([Tier Score]@row <= 17, "Tier 3", IF ([Tier Score]@row <= 25, "Tier 2", IF ([Tier Score]@row >= 26, "Tier 1"))) I keep getting UNPARSABLE. Thanks
Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…
Template with Dynamic view and Control Center
One of our templates relies on dyanmic view. Will the settings for Dynamic View stay in place when new project is created? All projects are created using Control Center. I've already searched in the Community, looked a articles, and learning.