IF Function Question - Symbol changes with date

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

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

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try something like this...


    =IF([email protected] = 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.

Sign In or Register to comment.