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


Question:

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,

Susan

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!