Newbie who needs help with If, and...
I am working on a formula where I need to be alerted by way of the red flag if a case is older than 180 days and open. The information for the date of incident is in the "Incident Date" column and I have a row with a check box for case closed or open- that row is "Case Closed?". I added a flag column as well.
I also created a report sheet that feeds to my dashboard so I can have it pull this specific data into the dashboard.
I need help with the formula and keep getting stuck. Any assistance would be greatly appreciated :)
Best Answer
-
@L@123 You have the date criteria set to flag if the date is more than 180 days in the future. I believe we need more than 180 days in the past.
=IF(AND([Incident Date]@row < TODAY(-180), [Case Closed?]@row = 0), 1)
Answers
-
=if(and(date@row >today()+180,status@row="Open"),1,0)
Give that a try and see what it does for you.
-
@L@123 You have the date criteria set to flag if the date is more than 180 days in the future. I believe we need more than 180 days in the past.
=IF(AND([Incident Date]@row < TODAY(-180), [Case Closed?]@row = 0), 1)
-
Ha. nice catch, that was pretty stupid by me.
Idk why but i never like putting the number of days inside the today formula. always use
=today()-180 instead of =today(-180). Same thing, just an odd tick i guess.
-
Haha. And I got used to putting them inside the parenthesis. As long as it works is what counts though.
-
Thank you so much- it worked!
-
Help Article Resources
Categories
Check out the Formula Handbook template!