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

MARP

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

vr

Heather

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

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

Is the acceptable range variable?

MARP

Hi @Paul Newcome,

Correct the variable range is -3 to 3.

Genevieve P.

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.

Cheers,

Genevieve