Data Validation in form rejecting everything

New Contributor

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.

2 Replies

@LisaM66 

=$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.

@Quadruple_Pawn Thank you I'll try that. I said I'd likely done something stupid! *facepalm*