Fighting an IF formula
I'm not sure what I am doing wrong. I am trying to get a response for "if the issue date is more than 10 days from the begin date AND the task is not 100%, show Late. Otherwise show 0. I will then be writing a report that shows only late.
=IF(AND(NETWORKDAYS(Begin1, Issue1) > 10, "Late", "0", [%Complete]5 < 1), "Late", "0")
Thanks!!
Comments
-
IF and AND are statements of their own. You need to think of them as independent when organizing your formulas. In your case you can use a stacked IF statement instead of an AND. If you want to get fancy and get your formula a little shorter you can use an or.
original
=IF(AND(NETWORKDAYS(Begin1, Issue1) > 10, "Late", "0", [%Complete]5 < 1), "Late", "0")
Stacked IF
=IF(NETWORKDAYS(Begin1, Issue1) > 10, "Late", if([%Complete]5 < 1), "Late", "0"))
IF OR
=IF(OR(NETWORKDAYS(Begin1, Issue1) > 10, [%Complete]5 < 1),"Late","0")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!