IF / OR

fredb
fredb ✭✭
edited 05/01/23 in Formulas and Functions

Hi,

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 !

Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!