IF / OR
I have two dates columns, one which will always be blank while the other will contain data. I simply need to calculate a due date depending on the column that is true and the one that is blank.
I was able to make a formula working on one column (IF([DATE CMD]@row = false; [DATE LIVRAISON]@row - 5), but struggling to formulate so the the two columns are counted in.
Please help !
Help Article Resources
Check out the Formula Handbook template!