hi
this is the original formula
=@IFS([@TABS]="","",AND([@TABS]<>"",COUNTA(Table2[@[Packet Ready to Print]:[Signed Doc Received snail mail]])=0), 7,AND([@TABS]<>"",[@[Packet Ready to Print]]="To Print"),5,AND([@TABS]<>"",[@[Packet Ready to Print]]="printed",[@[Packet Sent ]]=""),4,AND([@TABS]<>"",[@[Launched Date
DONE]]<>"",[@[Signed Doc Received Email]]="",[@[Signed Doc Received snail mail]]=""), 6,AND([@TABS]<>"",[@[Launched Date
DONE]]<>"",OR([@[Signed Doc Received Email]]<>"",[@[Signed Doc Received snail mail]]<>"")),0,AND([@TABS]<>"",[@[Packet Sent ]]<>"",[@[Meeting Date]]=""),3,AND([@TABS]<>[@[Meeting Date]]<>"",[@[Launched Date
DONE]]=""),1,AND([@TABS]<>"",[@[Invite Sent]]<>""),2)
i need to add: AND([@TABS]<>"",[@[Invite Sent]]="TERMINATED"),8 but itserroring since i dont know where to put it
this is the original formula
=@IFS([@TABS]="","",AND([@TABS]<>"",COUNTA(Table2[@[Packet Ready to Print]:[Signed Doc Received snail mail]])=0), 7,AND([@TABS]<>"",[@[Packet Ready to Print]]="To Print"),5,AND([@TABS]<>"",[@[Packet Ready to Print]]="printed",[@[Packet Sent ]]=""),4,AND([@TABS]<>"",[@[Launched Date
DONE]]<>"",[@[Signed Doc Received Email]]="",[@[Signed Doc Received snail mail]]=""), 6,AND([@TABS]<>"",[@[Launched Date
DONE]]<>"",OR([@[Signed Doc Received Email]]<>"",[@[Signed Doc Received snail mail]]<>"")),0,AND([@TABS]<>"",[@[Packet Sent ]]<>"",[@[Meeting Date]]=""),3,AND([@TABS]<>[@[Meeting Date]]<>"",[@[Launched Date
DONE]]=""),1,AND([@TABS]<>"",[@[Invite Sent]]<>""),2)
i need to add: AND([@TABS]<>"",[@[Invite Sent]]="TERMINATED"),8 but itserroring since i dont know where to put it