Date isn't today <> ""
Hello,
The below formula was suggested by the community experts, but I had a follow-up questions:
=IF([Target Start Date]@row <> "", IF([Target Start Date]@row <= TODAY(365), "Advanced", "Experts Only"))
What is the purpose of the first part of the formula where it says, "IF([Target Start Date]@row <> "". Why do we need to check if theTarget Start Date isn't today?
Thanks,
AE
Best Answers
-
That part of the formula checks to see if the Target Start Date is not blank. '<>' is formula speak for 'does not equal' and the two apostrophes "" mean blank. So the formula first checks to see if that field is blank, if it is not blank than it moves on to determine if it is Advanced or Experts Only. Without that part of the formula, you would get values for blank cells.
Try popping in the formula without that part and you can see for yourself
=IF([Target Start Date]@row <= TODAY(365), "Advanced", "Experts Only")
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
The reason for checking if it is not blank is because a blank cell is considered to be less than today's date. That means blank cells would generate an output of "Advanced". So by saying to only run if the [Target Start Date] isn't blank, we avoid this.
Answers
-
That part of the formula checks to see if the Target Start Date is not blank. '<>' is formula speak for 'does not equal' and the two apostrophes "" mean blank. So the formula first checks to see if that field is blank, if it is not blank than it moves on to determine if it is Advanced or Experts Only. Without that part of the formula, you would get values for blank cells.
Try popping in the formula without that part and you can see for yourself
=IF([Target Start Date]@row <= TODAY(365), "Advanced", "Experts Only")
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
The reason for checking if it is not blank is because a blank cell is considered to be less than today's date. That means blank cells would generate an output of "Advanced". So by saying to only run if the [Target Start Date] isn't blank, we avoid this.
-
Thank you Dan and Paul!
Amy
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!