GSS formula

Fill automatic score from gf
=ARRAYFORMULA(E2+(A2:A100))
=ARRAYFORMULA(IFERROR(B2:B16*C2:C16, " "))  

Auto copy file from other gss
=importrange("https://docs.google.com/spreadsheets/d/1uG-dsARXaDJUNtNdIewvdI5HRzNoHVN7eyzSJzLJy6w/edit?usp=sharing", "Sheet1!a16")
=importrange("https://docs.google.com/spreadsheets/d/1uG-dsARXaDJUNtNdIewvdI5HRzNoHVN7eyzSJzLJy6w/edit?usp=sharing", "Sheet1!b16")
=importrange("https://docs.google.com/spreadsheets/d/1uG-dsARXaDJUNtNdIewvdI5HRzNoHVN7eyzSJzLJy6w/edit?usp=sharing", "Sheet1!A16:b16")  
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1KLEiYh6yAjFHxPacgIbOQYhtmUgibGfb2ZfGFiECCkk/edit?usp=sharing","Monitor!B12:D12")
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1KLEiYh6yAjFHxPacgIbOQYhtmUgibGfb2ZfGFiECCkk/edit?usp=sharing","Monitor!A1:j42")
=importrange("https://docs.google.com/spreadsheets/d/1uG-dsARXaDJUNtNdIewvdI5HRzNoHVN7eyzSJzLJy6w/edit","Sheet1!a16") 

If
=IF(ISBLANK(A1); "Failed"; "Valid")
=IF(COUNT(A1)>0; "Valid"; "Failed")

=IF(B2>90, "A", IF(B2>70, "B", IF(B2>50, "C", "D")))  
=IFS(B2>90, "A", B2>70, "B", B2>50, "C", TRUE, "D")