How can i use symbols of 4 different colors for the following scenarios?

marcusben
marcusben ✭✭
edited 09/23/21 in Formulas and Functions

could you help me please?

There are 2 parts;

part 1; contract notice period,

part 2; contract expiry time


for part1;

If the day remaining until the notice of termination is over 60 days; Green


If it is between 60 - 15 days; blue


If between 15 and the termination notice period;

Yellow


If the notice period for termination has passed; Red



and for part2;

if the days remaining until the end of the contract is over 60 days; Green


If it is between 60 and 30 days; blue


If it is between 30 and 0 days; yellow


if the contract is delayed; Red

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try these...


    Part 1:

    =IF([Termination Date]@row >= TODAY(60), "Green", IF([Termination Date]@row >= TODAY(15), "Blue", IF([Termination Date]@row >= TODAY(), "Yellow", "Red")))


    Part 2:

    Use the same logic but update the column name and days within the TODAY function.

    thinkspi.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!