Google-sheets – Google Sheets: Freeze vs Protect

google sheets

enter image description here

I have a sheet (screenshot attached) . The first 3 rows are header rows and are frozen . I noticed that a formula that I'd put into U3 in the header 

=ARRAYFORMULA({"days since";IFERROR(IF(V4:V*1<>0,DATEDIF(V4:V,TODAY(),"D"),))})

was gone with just "days since" in that cell. Then I removed "days since" and refreshed the browser. I expected this to be protected, but it did not reappear (screenshot) . Is this normal behaviour. If so how do you protect header rows from change?

Best Answer

Yes that's normal.

Note: The screenshot shows that U3 hasn't a formula.

Related Topic