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 of range (F9:F18) to “P” if the value of F5 is “True” is it possible to do that?

Thanks

​Hicurrently 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 of range (F9:F18) to “P” if the value of F5 is “True” is it possible to do that?Thanks  Read More

​