If this and this and this then.......
I am trying to figure out a formula to tell me if something is "Currently Active". The way I have it setup currently is if today() is within my start date and end date cells it shows "True" in my Currently Active cell. I am using this formula.
=IF(AND(TODAY() >= [Impairment Start Date]2, TODAY() <= [Impairment End Date]2), "True", "False")
In addition to the date range I also want to look at the approval status column and if green = "True"
This would tell me if todays date is within the range specified and the approval status is green I would get a "True" statement in my Currently Active column. I want the Currently Active column to show false in the case of row 2 in snapshot.
Best Answer
-
You're almost there!
=IF(AND(TODAY() >= [Impairment Start Date]@row, TODAY() <= [Impairment End Date]@row, [Approval Status]@row = "Green"), "True", "False")
Answers
-
You're almost there!
=IF(AND(TODAY() >= [Impairment Start Date]@row, TODAY() <= [Impairment End Date]@row, [Approval Status]@row = "Green"), "True", "False")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!