Nested IF function - Ignore Blank Cells
I'm trying to count the number of late tasks in a project plan. The formula I'm using works as long as a row isn't blank. =IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""). If I drag the formula all the way down the sheet, then the Late Tasks column populates with a 1. How do I write the formula to not include blank rows?
Tags:
Comments
-
Will you ever have a blank finish? If not, then try this:
=IF(isblank(Finish15),"", IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""))
-
That worked. Thanks Mike!
-
Thanks! Glad I could help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am attempting what I thought was a simple formula to collect a value from the 'Week" column if today's date falls between a Start Date and an End Date. Here's what I have so far which returns an #IN…
- For other sheets, we use formula =IF(ISBLANK([Manually Actioned By]@row), NETWORKDAYS(Created@row, TODAY()), NETWORKDAYS(Created@row, [Manual Actioned Date]@row)) to tell us the turnaround time for th…
- I'm trying to get a running total based on if a certain drop down is used, in this case its value income total value. So if sales income is used multiple times i need the running total?