If this and this and this then.......

brianw ✭✭✭
edited 11/12/21 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!