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
Options
Victoria Ganuelas
✭✭✭✭
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?
Comments
-
Victoria,
=MIN(your current formula here, 150)
Craig
This discussion has been closed.