I need help with If formula


Hi there Im pretty new to smartsheet and trying to get a stsus column to return a symbol value based upon date and progress column

I'm tyring to get the following

IF date is in thepast and progress is nt 100% = RED

IF Progress is 100% = GREEN

IF date is future and progress is not 0% = YELLOW

IF date is today and progress is 0% = RED

IF date is future and progress is 0% = Grey

When I've applied simple IF formulas based upon just date it returns the word (RED, YELLOW etc..) rather than the coloured symbol

Can anyone help?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!