I need help with If formula

Options

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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!