I have this formula that does not work, really stumped. I've worked through this several times and just can't quite get it.
=IF(ISNUMBER(Find("4",Priority)),"Deferred",(IF(ISBLANK([Close Date]),(IF(ISBLANK([Actual Fix Date]),(IF(ISBLANK([Estimated Fix Date]),"Open","Accepted"),"Fixed"),"Closed"))
The calculated formula checks for if the priority is deferred, because if so the overall status is then deferred. It then checks if there are any values for dates in 3 columns. Please let me know if there is something blatantly wrong or if there is another way to go about doing this, thank you!