Change status if progress bar changes (help w/syntax)
Hello I want the status to change if the progress bar is changed. I tried a formula but only have it half working.
=IF(AND(Progress1 > "Empty", Progress1 < "Full"), "In Progress", IF(Progress1 = "Full", "COMPLETED!")
This is the formula. I want the status to show either 'Not Started' , 'In Progress', or COMPLETED! based on the progress of status bar. I only have the last part full= completed bit working... any help?