IF function and returning a blank cell
Hi!
I've tried several different versions of this function and haven't had any luck so far getting it to work. I want the function to return Yes, No, or stay blank as a way to indicate whether tasks were completed on time. Yes means the task was completed on time, No means the task was late, and blank means the task hasn't been completed yet.
I got the Yes/No part to work, but can't figure out how to get the function to return a blank cell. Here's what I have so far:
This part works on its own: =IF([Completion Date]22 <= [Due Date]22, "Yes", "No")
Here's where I'm struggling: =IF([Completion Date]21 <= [Due Date]21, "Yes", "No"), IF(ISBLANK([Completion Date]21), ""))
I think I need to use the ISBLANK function, but not positive. It seems like there's an easy fix that I'm just not seeing. I've also tried "0" and <>"" in place of the "".
Thanks for any help!
Answers
-
=IF(ISBLANK([Completion Date]21), "", IF([Completion Date]21 <= [Due Date]21, "Yes", "No"
-
Thank you!!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.2K Get Help
- 386 Global Discussions
- 212 Industry Talk
- 445 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!