Formula to prevent wrong input
Hello,
I need a bit of further help. I have two columns A & B for inputting numbers. A is the upper limit and B the lower limit. They are both required to be filled. It is quite possible that the persons inputting the data may inadvertently put the lower value in the upper limit column (A) and visa versa. Can a formula be created to prevent this from happening?
Answers

The numbers are inputting on a form.

Hi @Vinton Douglas
In Smartsheet, you can't directly prevent users from entering incorrect values via a form using a formula, you can create a formula in your intake sheet using helper column to flag entries where the value intended for the upper limit (column A) is lower than the value for the lower limit (column B). This way, you can easily identify incorrect entries and take action accordingly.
Here's a simple approach to flagging these instances:
 Create a new column (let's call it "Check Limits").
 In the first row of the "Check Limits" column, enter the following formula and convert it to column format formula:
=IF(AND(A@row <> "", A@row <> ""), IF( A@row < B@row, "Incorrect", "Correct"), "")
then you can create an automation to notifying you about wrong inputs using the "Check Limits" helper column in your automaton.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Hi Vinton, No... there isn't a way to validate the input on a form beyond ensuring things like that it's a number or email. You could create a formula on the sheet (that would calculate once the form is submitted) to flag the input error. From there you could do anything from highlight the cells with conditional formatting to using an automation to notify someone.
Hope this helps.
Be well
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!