REPLICATING THE AT RISK FORMULA FROM THE PROJECT SHEET TEMPLATE

Yabadabado@1962

I've been trying to replicate the "at risk" formula using due date and complete task criteria that is appears in the project sheet template. I can get each half of the formula to work independently but when i try to join them with AND i receive a #incorrect argument set error. Here's the formula:

=IF(AND([Due Date]1 < TODAY(), NOT(Status1 = "Complete"), 1, 0))

Its in a flag column. I guess there is something wrong with the ranges but i think tried everything.

Please can someone help.

Regards

Find more posts tagged with

Accepted answers

Genevieve P.

^ To add to what Paul said, it looks like one of the closing parenthesis needs to be moved further in. You'll want to close off the AND statement before moving on to the output of "1":

=IF(AND([Due Date]1 < TODAY(), NOT(Status1 = "Complete")), 1, 0)

The double should be after "Complete", not at the very end.

All comments

Paul Newcome

Try removing one of the closing parenthesis from the end of the formula.

Genevieve P.

^ To add to what Paul said, it looks like one of the closing parenthesis needs to be moved further in. You'll want to close off the AND statement before moving on to the output of "1":

=IF(AND([Due Date]1 < TODAY(), NOT(Status1 = "Complete")), 1, 0)

The double should be after "Complete", not at the very end.

Paul Newcome

@Genevieve P Good catch on the AND statement. I missed that part. Thanks!

Genevieve P.

Haha no problem! It was your comment that helped me see the AND... though in all honesty I haven't tested the formula yet.

@Yabadabado@1962 let us know if this works!

Yabadabado@1962

Thanks guys - so simple!😀

Paul Newcome

Happy to help! 👍️

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.