Calculated Column

%3CLINGO-SUB%20id%3D%22lingo-sub-2155820%22%20slang%3D%22en-US%22%3ECalculted%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155820%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20calculated%20column%20that%20shows%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(%5BCOL1%5D%3D%22Yes%22%2CISBLANK(%5BCOL2%5D)%2CISBLANK(%5BCOL3%5D)%2CISBLANK(%5BCOL4%5D)%2C%22NOT%20COMPLETE%22%2C%22COMPLETE%22)%3C%2FP%3E%3CP%3EHowever%20i%20have%20noticed%20the%20last%20condition%20it%20is%20bypassing%2C%20i%20believe%20this%20is%20because%20its%20a%20choice%20column%3F%3F%20Has%20anyone%20experienced%20this%20or%20do%20I%20need%20to%20write%20this%20in%20another%20manner%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20help%20would%20be%20greatly%20appreciated%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2155820%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hi Community

 

I have a calculated column that shows 

 

=IF(AND([COL1]="Yes",ISBLANK([COL2]),ISBLANK([COL3]),ISBLANK([COL4]),"NOT COMPLETE","COMPLETE")

However i have noticed the last condition it is bypassing, i believe this is because its a choice column?? Has anyone experienced this or do I need to write this in another manner?

 

Some help would be greatly appreciated :)

0 Replies