Conditional Formula with Date requirment
Im having trouble combing a conditional formula. Both parts work on their own but when I try to join them it breaks.
So far this is what i have
=IF(AND([FINISH]1< [Go live Date]1), IF(Status1 = "In Progress", 1, IF(Status1 = "Not Started", 1, IF(Status1 = "At Risk", 1,0)))))
I'm trying to do a numerical count. If the Finish date is not past the Go live date and the status is either In progress, At Risk, or Not started then the formula should pull 1. If it does not fit these requirements than the formula should pull 0.
Any idea on what I'm doing wrong?
Best Answer
-
Hi @Ryan Jared
Try
=IF(AND([FINISH]@row< [Go live Date]@row, OR(Status@row = "In Progress", Status@row= "Not Started", Status@row = "At Risk")), 1, 0)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Ryan Jared
Try
=IF(AND([FINISH]@row< [Go live Date]@row, OR(Status@row = "In Progress", Status@row= "Not Started", Status@row = "At Risk")), 1, 0)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
That worked, thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
