Hello,
I’m using Google spreadsheet and I had to start to use arrayformula so my formula can reapeat all the way down but when I apply a filter view, the array formula is not woeking anymore, is not visualizing my data.
Can someone please help me with this plese?
I found this solution, seams like that is working.
=ArrayFormula(if(row(A:A)=1,“Grade”,if(B:B>900,“A”,if(B:B>700,“B”,if(B:B>500,“C”,if(B:B>0,“D”,))))))
Also consider using an IF column within glide. Then you wouldn’t have to worry about using an array formula in the sheet, and it would give instant results if the grade value changed instead of waiting for the result to calculate on the sheet.