Color Coding Formula

Carlos Yanes
Carlos Yanes ✭✭✭✭✭
edited 08/19/20 in Formulas and Functions

Hey all,

Need some help with putting together a formula that will display color coding in a symbol column based on conditions being met in two other columns.

Under status there are the following options - Completed, In Progress, Not Started, On Hold. I'm trying to get the color coding to function as follows -

If Completed = color code health column as Green (will be using symbol colors)

If In Progress and the Estimated Launch Date is in the future from today's date then Green

If In Progress and the Estimated Launch Data is in the past then it should be Red

If On Hold then Yellow

If Not Started then Gray

Best Answer


  • Carlos Yanes
    Carlos Yanes ✭✭✭✭✭

    Thank you! This worked perfectly.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!