I'm trying to add more than one if's (also) statements inside a formula, but it is not working because of a syntax error. What I'm trying to do is if actual sign date column is less or equal to the expected date column (both date fields), to change the color in green, else to be blue-ish.
Also I'm trying to add into that same formula if the column named 'Confirmation Read And Agreed' is blank (empty) and the expected sign date is less than the date column set to today's date 'Today' (basically if expected sign date is overdue), to bring me a red color on that column. Do please have a look at the formula below.
=IF([Actual Sign Date]<=[Expected Sign Date] ,"<div style= 'background-color:#00CC00;'>" &[Actual Sign Date] &"</div>" ,"<div style= 'background-color:#00ffff;'>" &[Expected Sign Date] &"</div>" ,IF(ISBLANK[Confirmation Read And Agreed] && [Expected Sign Date]<[Today] ,"<div style= 'background-color:#FF0000;'>" &[Confirmation Read And Agreed] &"</div>" ) )