Project Status Color in Status Field

Hello community!

I want to put a field in summary to query the project end date in the project end date field within sheet summary and apply a RYG status based on a defined amount of time to end date. Is this possible? Does this even make sense? Is there a better solution someone has achieved?

Project End Date = 11/30/2023 - Still In progress

Best Answers

  • John_Foster
    John_Foster ✭✭✭✭✭✭
    Answer ✓

    Hi @Michele R. ,

    I believe that there was an extra [end date] in the formula you were using. In addition, I have modified the output values to the way they display with capitalisation.

    =IF([End Date]1-TODAY()>30,"Green",IF(AND([End Date]1-today()<30,[End Date]1-today()>0),"Yellow","Red"))

    Hope this helps!

    John

  • John_Foster
    John_Foster ✭✭✭✭✭✭
    Answer ✓

    Hi @Michele R. ,

    I have looked at the formula you have used and you do not have two arguments. I have modified the formula as per below which should work.

    =COUNTIF([End Date]:[End Date], @cell > TODAY())

    Thanks,

    John

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!