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})), monday.com 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
1 Like
Hi @Diego1,
How about creating another formula?
IF(ADD_DAYS({Open Date},{Days to Open})<TODAY(),"Expired","")