Thanks. I did also try it without the hyperlink part and it came up with the same.
=ArrayFormula(IF(ROW($A:$A)=1,“Rating”, IF(AE:AE="","",IMPORTJSON(CHAR(34)&AF:AF&CHAR(34),“result/rating”))))
Thanks. I did also try it without the hyperlink part and it came up with the same.
=ArrayFormula(IF(ROW($A:$A)=1,“Rating”, IF(AE:AE="","",IMPORTJSON(CHAR(34)&AF:AF&CHAR(34),“result/rating”))))