If in a column shows 100%, I would like it to automatically update as "Complete"

Ligy Alakkattussery

Hello,

If in a column shows 100% (this info is from another sheet), I would like it to automatically update as "Complete".

I tried the formula, =IF([% Complete]Status20 = 1, "Complete") but it is not working.

When I put the formula below, it works for "In Progress" and " Not Started" but I can't seem to get to work for "Completed

=IF([Total Completion]20 > "0%", "In Progress", IF([Total Completion]20 = "100%", "Completed", "Not Started"))

Thanks

Ligy Alakkattussery

Thanks Dan!

I watched your video. Very well explained and clear.

Bonus for explaining the Index Match functionality, I am not there yet but looking forward to using it.