I believe it's because the first IF statement in your code does not have a value for when Name is not equal to Production Completed. It should look something like this, my addition is in Red font.IF({DE:PD - WIP Name}='Production Completed',IF({status}='CPL',"Yes","") , You need to add something he...