REPLICATING THE AT RISK FORMULA FROM THE PROJECT SHEET TEMPLATE
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
Best Answer
-
^ 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.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Try removing one of the closing parenthesis from the end of the formula.
-
^ 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.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P Good catch on the AND statement. I missed that part. Thanks!
-
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!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks guys - so simple!😀
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!