Date based Priority dropdown formula

I have a target completion date column. If this date is within 14 days, I would like the "exclamation mark" to automatically populate. Is there a formula for this?


Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @Blake

    Hi Blake. Here you go. If you need help further defining extra criteria, just let me know.

    Example sheet:

    Risk Level formula:

    =IF(AND([Target Completion Date]@row >= TODAY(), [Target Completion Date]@row <= TODAY(14)), "High", "")

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @Blake

    Hi Blake. Here you go. If you need help further defining extra criteria, just let me know.

    Example sheet:

    Risk Level formula:

    =IF(AND([Target Completion Date]@row >= TODAY(), [Target Completion Date]@row <= TODAY(14)), "High", "")

  • @Mike TV

    You are awesome my friend. This works great. Thanks for helping out a new Smartsheet user. Smartsheets are transforming our workflows and processes at work. Your help is much appreciated!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!