Formula issue

Susan van Niekerk

Hi

Have built this formula

I need to return a "High" symbol if my DD helper Column is greater than 10 working days, a "low" symbol if < than 10 working days and if the DD helper column is blank then return blank - but i am getting an error

DD 10 Day helper column is set with a record the date automation - when the status changes to Due Dilgence

=IF(ISBLANK([DD 10 Day - Helper Column]@row), "", IF(WORKDAY([DD 10 Day - Helper Column]@row, 10) < 10, "low", "high"))

AndyJW

WORKDAY returns a date, i.e. 10 days after the helper column.

You need to use NETWORKDAY to get the number of days between the helper column and today.

=IF(ISBLANK([DD 10 Day - Helper Column]@row), "", IF(NETWORKDAY([DD 10 Day - Helper Column]@row, TODAY()) < 10, "low", "high"))

AndyJW

WORKDAY returns a date, i.e. 10 days after the helper column.

You need to use NETWORKDAY to get the number of days between the helper column and today.

=IF(ISBLANK([DD 10 Day - Helper Column]@row), "", IF(NETWORKDAY([DD 10 Day - Helper Column]@row, TODAY()) < 10, "low", "high"))