I am making a basic project tracker which has a Target Finish, Days Left and a Date Cleared column. Currently the Days left column autocompletes from the Target Finish and if there is a Date Cleared entry then the Days left becomes Complete. However if I don't have any value in Target finish then Days left becomes -42471. I want to edit my formula to make it so if there is no Target finish date nothing shows up in Days left.
My formula is currently =IF(ISBLANK([@[Date Cleared]]),[@[Target Finish]]-TODAY(),"Complete")
File attached
Bookmarks