Need a checkbox checked if two items are true / Code not working
looking at an item on line that will give me access to everything that is past due or due within the next two weeks on a project schedule. We built a report but it does not give the parent task associated with the child task. I googled and got something similar to what I need but not quite there.
Here is what I need:
I need a check mark to be set in a checkbox if the following is met:
Where the Parent = Yes (have a Parent task column), Status not equal to Complete, start date in the past and due date in the future and that has a Parent Task = No, status not equal to Complete and a due date either in the past or in the next 14 days.
Here is my code that is not working:
=IF(([Parent Task]@row, = "Yes", Status@row, != "Complete", [Start Date]@row, < TODAY(), [Due Date]@row, > TODAY()), 1, 0), IF(AND([Parent Task]@row, = "No", Status@row, != "Complete", [Due Date]@row, < TODAY() OR [Due Date]@row, = TODAY(14)), 1, 0))
Not sure what I am doing wrong here, any assistance would be great :o)
Caroline
Best Answer
-
Try this:
=IF(Status@row <> "Complete", IF(OR(AND([Parent Task]@row = "Yes", [Start Date]@row< TODAY(), [Due Date]@row> TODAY()), AND([Parent Task]@row = "No", [Due Date]@row<= TODAY(14))), 1)
Answers
-
Try this:
=IF(Status@row <> "Complete", IF(OR(AND([Parent Task]@row = "Yes", [Start Date]@row< TODAY(), [Due Date]@row> TODAY()), AND([Parent Task]@row = "No", [Due Date]@row<= TODAY(14))), 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!