I want to create a formula that would dispute 1 out of 3 message depending upon the content.
I currently have a formula grabbing the data from the CCTV Warranty Expire cell and if it's less than today's date, it's displaying "Out of Warranty" in the CCTV Warranty Status column. If it's greater than today's day, it will display "In Warranty". However I noticed that when the CCTV Warranty Expire column is blank, it will still display the Out of Warranty statement. How do I add to this formula to state that if the CCTV Warranty Expire date is blank, then display "No Info Available"
=IF([CCTV Warranty Expire]2 > TODAY(), " In Warranty", "Out of Warranty")
Answers
-
Hello Bolz,
Try this nested if statement
=if(isblank([CCTV Warranty Expire]2), "No Info Available,IF([CCTV Warranty Expire]2 > TODAY(), " In Warranty", "Out of Warranty"))
Michael
-
Thank you so much. It was missing a " at the end of Available, but all worked correctly. Appreciate the support.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!