I am not very good with formulas and have attempted to create one, but it doesn't seem to be working.
I have a % complete column and then a "drop down" status column with "complete, in progress, not started and at risk". What I'd like to do is set up a formula that says if % complete is 100%, then status changes to "complete". If I can work it so other percentages are covered too, that would be awesome, but mainly I want the complete status.
Is this even an option? Thanks!
