Nested IF , AND formula
Hi, I've never used a combined IF with an AND function and I have to perform this function on a test (beginner level)
Use a nested-if formula to automate the RYG status balls in the "Status "column, depending on the "% Complete" for each request.
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
Do I put this formula in the status column that is already assigned as a symbol column with RYG balls - I think YES
There is a column named % Complete which is filled in with %s
My formula (error message = unparseable)
= IF([%complete]3<70%,”red”, IF(AND([% complete]3>=70%, [% complete]3<100%,)”yellow”,”green”))
What have I done wrong?
Thanks so much,
Help Article Resources
Check out the Formula Handbook template!