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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!