Forum Discussion
Data validation
Hi currently I am using google sheet. I need a function do the following case: I have data validation in the range (F9:F18) of the attached file. I need a function or formula to set all the values ...
Hello Ajl
yes, it is possible, select range (F9:F18) click data validation go to "Error Alert" and uncheck the error alert invalid entered, press OK
then go to your rage again select rane (F9:F18) write the following function (=if($f$5="true";"P";"").
Good Luck
Mohammed
Can I share the google sheet link here? I tried to do what you said but I could not. I hope it is possible to share