Nested IF Function using Harvey Balls
Hi SS Community,
I have the following nested IF column formula . The formula works properly through the "Red" part, but once I attempt to type DECLINED in the "Revised Final Date" column, the formula returns #invalidoperation. What can I change in my formula to show a Gray Harvey ball when I type DECLINED in the "Revised Final Date" column? Picture posted below.
Education Service Center Region 13
Grants and Contracts Project Coordinator
Help Article Resources
Check out the Formula Handbook template!