REPLICATING THE AT RISK FORMULA FROM THE PROJECT SHEET TEMPLATE

Yabadabado@1962

Hi

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

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

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! 👍️