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 :)
Help Article Resources
Check out the Formula Handbook template!