# IF Function Question - Symbol changes with date

Hello,

I have been having some issues configuring a formula in smartsheets. I am trying to write a function where the Symbol (Green, Yellow, Red, Grey Balls) in the 'Status' column adjusts according to date in the 'Start' column.

Green appears if the start date is 7 days in the future or beyond

Yellow appears if the start date is today or within 7 days

Red appears if the start date is before today

Grey appears if the 'Done' column is checked

Please let me know if you can help. Do I copy the same formula into every cell? Do I change the statud column to Text while entering the formula?

New to all of this thank you,

Kelly

• ✭✭✭✭✭✭

Try something like this...

=IF(Done@row = 1, "Grey", IF([Start Date]@row < TODAY(), "Red", IF(Start Date]@row <= TODAY(7), "Yellow", "Green")))

Once you enter this formula into one cell in the RYG column, you can use dragfill to quickly drag it down (or up) the rest of the column to fill in the rest of the cells.

• Thank you so much - this worked! Can you help me with what to add if I want nothing showing up if no date is entered?

• So great -- thank you for your help!

• ✭✭✭✭✭✭

Happy to help! 👍️

• This worked for me, except that the words GREY, GREEN, YELLOW, and RED are showing up instead of the symbols/balls. How can I correct this?

Thanks in advance for any help! :)

• ✭✭✭✭✭✭

@Brittney Sinkfield You will need to make sure the column type is set to Symbol and select the RYGG set of symbols. If I remember correctly, I also think that "Grey" is actually "Gray", and I do know that it is case sensitive. If the column type is already set properly, try changing the outputs to be an exact match to the colors including the case of each letter (first capital and rest lower).

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!