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

Duplicate Formula
I have a Smartsheet which is fed from a form an Intake team is using to gather prospect information and we are having issues with duplicate entries. The sheet/form has a field for prospect first name and another for prospect last name which we would like to check for duplicate entries of. I created a column combining both…
How to create a formula to pull the first part of an order number into an adjacent column
Hello! I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…