Formula for % complete is missing a rule

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

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.