Advance formula of Google sheet

 1.=D4+ SUMIFS(Sheet2!$L$3:$L,Sheet2!$J$3:$J,$B$4:$B)+sumifs(RETURN!$E$3:$E,RETURN!$C$3:$C,B4)-sumifs (TRANSFER!$E$3:$E,TRANSFER!$C$3:$C,B4)

2. =ARRAYFORMULA(IFERROR(VLOOKUP(C3:C,Sheet2!$B$4:$C,2,0),""))

3. =ARRAYFORMULA(if(B4:B,"PPF-RL-"&row(B2:B)-1+10000,""))

4. =IF(H4="PE",G4,IF(H4="PP",G4,IF(H4="PE PP",G4,"")))

5. =IF(H4="PE PP",G4,IF(H4="PP",G4,""))

6. =IFERROR(M4*N4/1000," ")

7. =ARRAYFORMULA(IF(O4:O=0,"PENDING","Complete"))

8. =ARRAYFORMULA(IF(P4:P="COMPLETE", HYPERLINK("https://docs.google.com/forms/d/e/1FAIpQLSd8DQvOYP3bWg0pojmdRI1a9lwJCqnspnn8ZW_iA0JVXr-iHQ/viewform?usp=pp_url&entry.2009608542="&A4:A&"&entry.820423580="&J4:J&"&entry.1551706892="&C4:C&"&entry.2022927099="&D4:D&"&entry.1318474386="&L4:L&"","Open"),""))

9. =ArrayFormula(if(C3:C="","",row(C3:C)-1))

10. =iferror(VLOOKUP(C3,'PPF PCS -IMS'!$B$4:$C$2503,2,0),)

11. =iferror(SUM(filter(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1qqfPKw6B2Cxn6veN1Y0oq-4RaXfiYRLjdzotVWeT42A/edit#gid=0","Transfer!$d$214:$d"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/1qqfPKw6B2Cxn6veN1Y0oq-4RaXfiYRLjdzotVWeT42A/edit#gid=0","Transfer!$b$214:$b")=B4)),0)

12. =(D4+E4)-SUMIF('PPF ROLL-PMS'!$E$4:$E$1001,B4,'PPF ROLL-PMS'!$F$4:$F$1001)

13. =iferror(INDEX($X$4:$X$11310,MATCH(I5,$V$4:$V$11310,0)),"")

14. =IF(O1,O1,IF(N1="DONE",NOW(),""))

15. =IF(N1<>"",IF(P1<>"",P1,(NOW()-A1)/24),"")

16. =ARRAYFORMULA(if(B2:B,text(ifna(VLOOKUP(A2:A,{'FORM RESPONSE'!B:B,'FORM RESPONSE'!A:A},2,0),""),"dd-mm-yyyy hh:mm:ss"),""))

17. =ARRAYFORMULA(if(B2:B,IF((M2:M+N2:N)>=L2:L,"Completed","Pending"),""))

18. =ARRAYFORMULA(if(B2:B,if(round(IFna(VLOOKUP(J2:J,Sheet2!$A$2:$E,5,0),"")*H2:H,0),round(IFna(VLOOKUP(J2:J,Sheet2!$A$2:$E,5,0),"")*H2:H,0),"NO DATA"),""))

19. =ARRAYFORMULA(if(B2:B,(G2:G*H2:H)/1000,""))

20. =ARRAYFORMULA(IF(B2:B,ifNA(VLOOKUP($J$2:$J,Sheet2!A1:E,2,0),""),""))

21. =ARRAYFORMULA(IF(O4:O="COMPLETED", HYPERLINK("https://docs.google.com/forms/d/e/1FAIpQLSd8DQvOYP3bWg0pojmdRI1a9lwJCqnspnn8ZW_iA0JVXr-iHQ/viewform?usp=pp_url&entry.2009608542="&A2:A&"&entry.820423580="&J2:J&"&entry.1551706892="&C2:C&"&entry.2022927099="&D2:D&"&entry.1318474386="&L2:L&"","Open"),""))