Return Text based on a date
I am trying to write a formula that will return the text "Current" or Expired in the INS status Column based on whether the dates in the GL, AUTO and WC dates are past today's date. Hitting a wall. Attached snip of the sheet
Thank you in advance for any help!
Comments
-
THANK YOU!!! That's perfect and works like a charm!
-
Just ran in to one instance where it did not work. 2 of the dates (GL and AUTO) are in June, but the WC was in February and it's returning a Current instead of the Expired. I'm playing with it but if you know of the top of your head! Thanks!
-
Hmm, I double checked mine and it seems to be working.
-If all three are in the Future = "Current"
-If one or more of them are Less than Today = "Expired"
Is that the logic you are looking for? If not, if you give a bit more detail I can revise the formula.
-
It seems like replacing the AND with OR should do the trick as it sounds like you are looking to flag as "Expired" if any of the dates are in the past.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K 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!