Not sure why I keep getting an Invalid Syntax error for this formula. I want it to return "Complete" in the cell when StepsDetailOpen column cell is blank. Below is the formula I'm using. Any thoughts??
Steps Detail Status: IIF([StepsDetailOpen]" ","COMPLETE")