Nov 18 2021 04:26 AM
I've set up a dummy form for testing input via forms and data validation (final file very big so wanted to test on something smaller). For some reason (after working fine yesterday) the data validation is now rejecting anything I try. I have probably done something stupid but can't figure out what it is.
Nov 18 2021 04:44 AM
=$G$2
=$G$3
I think you have to enter the data validation cell with " $ " like shown above. I changed this in your file for columns date, price and density and it seems to work.
Nov 18 2021 04:51 AM
@OliverScheurich Thank you I'll try that. I said I'd likely done something stupid! *facepalm*