IF Function Question - Symbol changes with date
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,