What is the nested IF formula for the following?

tmkj20

If a request is less than 70% complete, turn the "Status" column into a "Red" status ball

If a request is 70% or above and less than 100% complete, turn the "Status" column into a "Yellow" status ball

If a request is 100% complete, turn the "Status" column into a "Green" status ball

Nic Larsen

Try: =IF([% Complete]@row = 1, "Green", IF([% Complete]@row >= 0.7, "Yellow", "Red"))

Nic Larsen

Try: =IF([% Complete]@row = 1, "Green", IF([% Complete]@row >= 0.7, "Yellow", "Red"))

tmkj20

Perfect - thank you!