=IF(E2=TRUE,IF(AND(ISNUMBER(F2),F2>0),F2,TODAY()),"")
This formula was working; however, now I receive the following error:
"There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or moving the formulas to different cells."
Essentially, I want the date cell D was checked to populate cell F with the date is was checked.
Any help is greatly appreciated.
Bookmarks