Nested If Statements
I'm trying to check a box to indicate whether a remediation item has been opened or closed in the past year.
My relevant fields are report date, target date, and date closed. Date Closed could potentially be blank.
Here is the formula I've been trying to refine: =IF(OR(TODAY() - [Report Date]77 < 365, TODAY() - [Last Remed Target Date]77 < 365), IF(NOT(ISBLANK([Date Closed]77)), IF(TODAY() - [Date Closed]77 < 365, 1, 0, 0, 0)))
I'm sure my brackets are incorrect at this point. Can someone please help me correct this?
Help Article Resources
Check out the Formula Handbook template!