How to calculate the smallest value and equal value in two select
Patient_Eye_Survey.xlsx (15.2 KB)
Here are 2 solutions:
02Patient_Eye_Survey.xlsx (14.7 KB)
03Patient_Eye_Survey.xlsx (14.6 KB)
The second one uses a calculated read_only select, instead of a note. This may be better for data export, as you get the standard code/label option.
I changed your note to show the label of the minimum, instead of the code (name).
Thank you very much.