Formula issue

Susan van Niekerk

Hi Brian Trust

My formula wont work

LOGIC

• If the Helper Date Column is blank then the priority cell is blank
• If the Helper Date Column is less than 10 days, its Low Priority
• If the Helper Date Column is greater than 10 days, its High Priority?

FORMULA

=IF(ISBLANK([DD 10 Day - Helper Column]@row), "", IF(NETWORKDAYS(TODAY(), [DD 10 Day - Helper Column]@row) <= 10, "Low", "High"))

• f the Helper Date Column is blank then the priority cell is blank - WORKS

• If the Helper Date Column is less than 10 days, its Low Priority - WORKS

• If the Helper Date Column is greater than 10 days, its High Priority? - WONT WORK

What have I done wrong?

NicoLHC

@Susan van Niekerk its a pleaseure to meet you , great to see your engagement!

Try this instead:

working days

=IF(ISBLANK([DD 10 Day - Helper Column]@row), "", IF(NETWORKDAYS(TODAY(), [DD 10 Day - Helper Column]@row) <= 10, "Low", "High"))

 Calendar Days

=IF(ISBLANK([DD 10 Day - Helper Column]@row), "", IF([DD 10 Day - Helper Column]@row - TODAY() <= 10, "Low", "High"))