If Date is blank + past formula
I can't figure out why this would return a "yes" when the date cell is blank.
=IF([Date of Site Survey (Product)]@row = " ", " ", IF(TODAY() > [Date of Site Survey (Product)]@row, "yes", " "))
Intended logic/result -
If date cell is blank, then "blank" (this worked when I tried without the 2nd argument added)
If date is in the past, the "yes" - if not "no"
Please advise...thanks!
Best Answer
-
Try this:
=IF([Date of Site Survey (Product)]@row <> "", IF(TODAY() > [Date of Site Survey (Product)]@row, "yes", "no"))
Answers
-
Try this:
=IF([Date of Site Survey (Product)]@row <> "", IF(TODAY() > [Date of Site Survey (Product)]@row, "yes", "no"))
-
Thanks Paul! Can you point out how the <> worked vs my approach? How does that "read"?
-
<> ""
means "is not blank". So the way my formula reads is
IF the date is not blank then evaluate for IF TODAY is greater than the date...
-
Hi Paul. I used your formula above and it works really great on my sheet.
Currently I have this: =IF(Publication@row <> "", IF(TODAY() > Publication@row, "yes", "no"))
What I want to do is also only mark whether my publication is "Yes" when the column "Publication Complete" =0 (not checked). Do you know what I would need to include here? I have tried AND arguments but have returned UNPARSABLE.
Thanks in advance.
-
@Will Bastin Try this:
=IF(Publication@row <> "", IF(OR(TODAY()>Publication@row, [Publication Complete]@row <> 1), "yes", "no"))
-
@Paul Newcome Thanks so much. It worked great, I just use AND instead.
=IF(Publication@row <> "", IF(AND(TODAY()>Publication@row, [Publication Complete]@row <> 1), "yes", "no"))
Thanks for your help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!