I would like to create a calculated field which requires a digit. This digit must be between a Max and Min value which are two ListItems in another list. How can I create a formula for this calucated field to check that the value is not less than Min and not more than Max?
You can not because a Calculated Formula only operates on ONE Item in ONE List
So your workarounds
- make a workflow copy Min/Max values from List B to every ListItem in List A
- Use No Calculations; Let the View (using CSR or other scripting) display the incorrect value
- On every change Min/Max in List B, update the Formula in List A definition with those (hardcoded) values