google-sheetsgoogle-sheets-formula

IF Status Formula Google Sheet Approval


I need to know the status of my ticket approval.. =IF(A2="","",IF(B2<>"","FOR 2ND APPROVAL",IF(C2<>"","FOR 3RD APPROVAL",IF(D2<>"","FOR 4TH APPROVAL",IF(E2<>"","FOR 5TH APPROVAL",IF(A2<>"","FOR 1ST APPROVAL",""))))))

The status is not updating. Here is the sample I need in my sheet.

https://docs.google.com/spreadsheets/d/1x3Upa0qhTItyVjXiNwTaIsbajq4ac4cZsX7Pap27KGE/edit?gid=0#gid=0


Solution

  • You may try the following formula-

    =IF(A2="",,XLOOKUP(0,INDEX(--B2:F2),$B$1:$F$1,"APPROVED"))
    

    Dynamic spill formula-

    =BYROW(B2:F,LAMBDA(r,IF(INDEX(A:A,ROW(r))="",,XLOOKUP(0,INDEX(--r),$B$1:$F$1,"APPROVED"))))
    

    enter image description here