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

Index Match Returning Unexpected Value
I feel like I've posted 1000 Index Match questions this year! I have a formula (below) that is returning and individual who has the same Date Assigned field but not that same MLL ID. The MLL ID is supposed to be the thing that stops the date range from looking at all the cells. I'm trying to get Ciara as a returned value…
Returning txt in one cell depending on multiple check boxs with IF & AND
Hi, I'm trying to use IF & AND statements to return text to one cell depending on the condition of multiple check boxes. I have searched through the community posts and can't find the answer. Any help would be greatly appreciated. Below is what I have so that can't get to work. =IF(AND([Electric Disconnected]@row = 1,…
Formula error Unparseable
I've tried over and over again to correct this unparseable error without success. I've scanned the forum also. This is a pretty basic question I am unable to solve. Basically what I am trying to do is if the status ="Active New" then total the sum for the column 1st QTR 2024 In this forumla the 2 in bold are sheet…