Formula for % complete is missing a rule

vanstadenster

I have this formula which is working. However what it is not doing is picking up a Not started task sitting at 0% that it is overdue.

It only marks it as overdue once I move the task to an in- progress state.

=IF([Percent Complete]@row = 1, "Complete", IF([Percent Complete]@row = 0, "Not Started", IF(AND([Percent Complete]@row < 1, [End Date]@row <= TODAY()), "Overdue", IF([Percent Complete]@row > 0.01, "In Progress"))))

Paul McGuinness

Hi @vanstadenster

If you reorder your formula it will pick that up, your formula was reading the 0 and ending the formula at 'not started' hopefully now it will recognise overdue instances before those not started.

=IF([Percent Complete]@row = 1, "Complete", IF(AND([Percent Complete]@row < 1, [End Date]@row <= TODAY()), "Overdue", IF([Percent Complete]@row = 0, "Not Started", , IF([Percent Complete]@row > 0.01, "In Progress"))))

Hope that helps

Paul McGuiness
Central Operations Manager at Care UK

vanstadenster

Amazing I just removed the duplicate ,, before the last IF and it is working.