Past Due, 1 to 30 days , 31 to 60 days & 61 to 90 days

Options
Mukundraj
Mukundraj
edited 01/24/22 in Formulas and Functions

Hi Team,

I have a "Planned start date" column , I need data for Past Due, 1 to 30 days , 31 to 60 days & 61 to 90 days in once cell, could you help.

=IF(TODAY() > [Planned Start Date]@row, "Past Due", IF([Planned Start Date]@row <= TODAY(1-30), "Start < 30 Days"))


Out comes : "Past Due" "Start < 30 Days" "Start between 31 to 60 Days" & "Start between 61 to 90 Days"

Regards,

Mukund

Best Answer

  • Mukundraj
    Mukundraj
    Answer ✓
    Options

    I somehow found the formula

    =IF([Planned Start Date]@row < TODAY(), "Past Due", IF([Planned Start Date]@row <= TODAY(30), "Start < 30 Days", IF([Planned Start Date]@row <= TODAY(60), "Start between 31 to 60 Days", IF([Planned Start Date]@row <= TODAY(90), "Start between 61 to 90 Days", ""))))

Answers

  • Mukundraj
    Mukundraj
    Answer ✓
    Options

    I somehow found the formula

    =IF([Planned Start Date]@row < TODAY(), "Past Due", IF([Planned Start Date]@row <= TODAY(30), "Start < 30 Days", IF([Planned Start Date]@row <= TODAY(60), "Start between 31 to 60 Days", IF([Planned Start Date]@row <= TODAY(90), "Start between 61 to 90 Days", ""))))

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Mukundraj

    Thanks for posting your solution! I'm glad you were able to figure it out.

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!