multi level formul ifs counta mistake

[rjmdc]

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

 

[rjmdc]

after i finish the 3.5 hr refresh i will give it a try and report back
thanks for replying
can i change the no criteria to also be "8"

 

[Alex Blakenburg]

Sure it can be whatever you want to put in that position.

 

[rjmdc]

hi
it says this is not a formula
i corrected all the column names
what could be incorrect?

 

[RoryA]

Either the column names or the table name.

 

[rjmdc]

thanks
i found the error with a space in a column name
however i dont get the terminated clause correctely
whgere shold that be to supercede all other numbers?

 

[rjmdc]

thanks we are all good now
i moved the 8 to after the first clause
thank you so much
i appreciate the real help i receive

 

[RoryA]

At the start of the IFS formula - presumably before the first AND in your original formula as I assume you still want to default to "" if the TABS column is blank?

 

[rjmdc]

thanks we are all good now
i moved the 8 to after the first clause
thank you so much
i appreciate the real help i receive