Formulas and functions in forms



When building a form I am wondering if there is any way to include formulas or other ways to use logic to solve the case described below:

I have two input fields that the user will populate with numbers. Is there a way to compare the content of these two fields and then use logic to prompt new fields if content does not match?

I seems that this would be possible to do only if using drop down list type column. But the number that will be filled in the fields can be in the range of 1-99999999, meaning that a drop down list is not practical.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!