Date based Priority dropdown formula

Blake

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?

Mike TV

@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

@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", "")

Blake

@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!