I need to set a limit to a column


I need to collect info from my team on products we have on Amazon. Below are 2 maximum values for Amazon so maybe if someone tries to enter a higher value, it would give an error message or not allow them to enter it

  • Units Per Box: 150
  • Total Weight (LBS): 50

So for Unit Per Box, if they enter more than 150 it would allow then, and for Total Weight if they try to enter more than 50 it wouldn't allow. Its just a way for us to avoid errors.

I hope someone can help with a formula.

Thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!