Newbie who needs help with If, and...

Tabitha W.

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 :)

Paul Newcome

@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)

L_123

=if(and(date@row >today()+180,status@row="Open"),1,0)

Give that a try and see what it does for you.

Paul Newcome

@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)

L_123

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.

Paul Newcome

Haha. And I got used to putting them inside the parenthesis. As long as it works is what counts though.

Tabitha W.

Thank you so much- it worked!

Paul Newcome

Great! Happy to help. 👍️