Setting formulas as due dates

Hi monday community. I have many boards where the due dates depend on another date on the same item or line. However, when I use the formula FORMAT_DATE(ADD_DAYS({Open Date},{Days to Open})), doesn’t allow me to set that formula column as a deadline. This is not so useful to us because it returns a simple date column with no indicators on whether it is expired

Hi @Diego1,

How about creating another formula?

IF(ADD_DAYS({Open Date},{Days to Open})<TODAY(),"Expired","")