Can Forms display "FAILED" if result are outside expected ranges.

edited 09/25/23 in Formulas and Functions

I think I have a guess on the answer but was hoping someone figured out a work around or provide some guidance.




  • Eric Law
    Eric Law ✭✭✭✭✭✭

    @MARP What do you mean? For numbers? For names? For dates? What is the range? Would a dropdown work better for you?

  • MARP
    MARP ✭✭

    When a technologist is performing their quality control test on their equipment, there is a range that is acceptable. If their QC result is not within that given parameter can Smartsheet state "fail" if the entry is not within the acceptable range.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
  • MARP
    MARP ✭✭

    Hi @Paul Newcome,

    Correct the variable range is -3 to 3.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @MARP

    In order for us to come up with possible solutions, it would be very helpful if we were able to see an example of how you currently have your set-up (screen captures of your form - but block out sensitive data).

    If your "variable range" is a single dropdown with numbers, then you can set up Conditional Logic in your Form to show a Header & Description if either -3, -2, -1, 0, 1, 2 or 3 are selected.

    However keep in mind that forms cannot perform calculations, meaning if you want the Form to SUM values that are selected in multiple fields, this is not currently possible. You will need to do that in the underlying sheet with a formula, then you could send an automated alert to the Form submitter afterwards.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!