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

 

[RoryA]

Copy it from your first post here and paste it into a cell in whatever column in your table it originally came from.

 

[rjmdc]

i set it up so iu can see clearly the numbers
your formula produces the error notr a formul
=@IFS([@TABS]="","",COUNTA(Table2[@[Packet Ready to Print]:[Signed Doc Received snail mail]])=0, 7,
AND([@TABS]<>"",[@[Packet Ready to Print]]="To Print",5,
AND([@[Packet Ready to Print]]="printed",[@[Packet Sent ]]=""),4,
AND([@[Launched Date DONE]]<>"",[@[Signed Doc Received Email]]="",[@[Signed Doc Received snail mail]]=""), 6,
AND([@[Launched Date DONE]]<>"",OR([@[Signed Doc Received Email]]<>"",[@[Signed Doc Received snail mail]]<>"")),0,
AND([@[Packet Sent ]]<>"",[@[Meeting Date]]=""),3,
AND([@[Meeting Date]]<>"",[@[Launched Date DONE]]=""),1,
[@[Invite Sent]]="TERMINATED",8,[@[Invite Sent]]<>"",2)

original formula produces the #NA instead of the 8 that i need which is breaking other books that PQ

=@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)

please help amend yours so it works

 

[RoryA]

What is the actual name of your Launched Date DONE column? The one you posted originally had a carriage return in it after the word Date, but neither of the ones you posted just now do.

 

[RoryA]

If there is no carriage return in the actual name, then the formula is:

=@IFS([@Tabs]="","",COUNTA(Table2[@[Packet Ready to Print]:[Signed Doc Received snail mail]])=0, 7,[@[Packet Ready to Print]]="To Print",5,AND([@[Packet Ready to Print]]="printed",[@[Packet Sent ]]=""),4,AND([@[Launched Date DONE]]<>"",[@[Signed Doc Received Email]]="",[@[Signed Doc Received snail mail]]=""), 6,AND([@[Launched Date DONE]]<>"",OR([@[Signed Doc Received Email]]<>"",[@[Signed Doc Received snail mail]]<>"")),0,AND([@[Packet Sent ]]<>"",[@[Meeting Date]]=""),3,AND([@[Meeting Date]]<>"",[@[Launched Date DONE]]=""),1,[@[Invite Sent]]="TERMINATED",8,[@[Invite Sent]]<>"",2)

 

[rjmdc]

Launched Date
DONE
seems lik there is a carriage return

 

[rjmdc]

i tried with a carriage return it still says ot a fomula

 

[RoryA]

Did you try what I said about copying your original formula from the forum and pasting it back into the original table? If so, did it work?

All I can tell you is that the formula I posted does work on a table set up using the headers from your original formula as posted.

 

[rjmdc]

still says not a formula
=@IFS([@TABS]="","",COUNTA(Table2[@[Packet Ready to Print]:[Signed Doc Received snail mail]])=0, 7,
AND([@TABS]<>"",[@[Packet Ready to Print]]="To Print",5,
AND([@[Packet Ready to Print]]="printed",[@[Packet Sent ]]=""),4,
AND([@[Launched Date
DONE]]<>"",[@[Signed Doc Received Email]]="",[@[Signed Doc Received snail mail]]=""), 6,
AND([@[Launched Date
DONE]]<>"",OR([@[Signed Doc Received Email]]<>"",[@[Signed Doc Received snail mail]]<>"")),0,
AND([@[Packet Sent ]]<>"",[@[Meeting Date]]=""),3,
AND([@[Meeting Date]]<>"",[@[Launched Date
DONE]]=""),1,
[@[Invite Sent]]="TERMINATED",8,[@[Invite Sent]]<>"",2)

 

[RoryA]

Did you try what I said about copying your original formula from the forum and pasting it back into the original table? If so, did it work?

 

[rjmdc]

my original formula gives me the #NA
i need to fix that with the terminated clause
please help me add the terminated =8 so i dont get the #NA