In my board I have every invoice that we’ve generated. I have a column with the date of the invoice creation and a column with days of payment. In another column, using the function add_days, I add these two up; so if the invoice was created on March 2nd and the days of payment are 30, the due date for payment is calculated as April 1st.
The problem is that I can’t use any automation because the formula column cannot be seen as a date column even if the values are set as a date. What I’m trying to do is automatically change the status of the invoice (In time, Overdue, Overdue 30+) etc depending on my due date column.