Nested IF formula with Multiple conditions
I am trying to create a formula in the status column and I keep getting an error message. I wanted to make the status column a calculation to limit the amount of work the editors has to do.
I have never been great with nested if statements, but I got it to work in Excel. I was able to get a simple If statement formula to work but am stuck on this one. I keep getting an #Unparseable error. I am cross-eyed now trying to figure out the problem. Is this something you can help me with?
Desired Formula is:
If actual completion date is blank and the planned completion date is less than today, "Not Started"
If actual completion date is blank and the planned completion date is greater than today, "Late, Not Started"
If actual completion date is less than planned completion date, "Complete"
If actual completion date is greater than planned completion date, "Complete Late"
Help Article Resources
Check out the Formula Handbook template!