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,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!