IF Function Question - Symbol changes with date

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

Best Answer

Answers

Sign In or Register to comment.