I would like to nest an additional function at the “then” part of the IF formula:
IF(JobDoneOn = “”, “Due” , DATETIME_FORMAT(JobDoneOn , ‘DD/MM/YY’))
So that it reads:
IF(JobDoneOn = “” , “Due” & DATETIME_FORMAT(NextDue, ‘DD/MM’) , DATETIME_FORMAT(JobDoneOn, ‘DD/MM/YY’))
Any ideas?