Auto Populate Date Column Per Two Existing Columns

I would like to auto populate a PILOT DUE DATE column with a date that is 10 business days from the PDF APPROVED DATE column, when the COLOR PROOF column contains "PILOT".

I thought i had a moderate grasp of formulas, but i have no idea how to even start this one.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!