If/Then Formula with Projected Dates

I am looking to create an if/then formula for the below.

I have 2 columns (projected start and projected complete) and I am trying to calculate the projected complete date for a project, but it is dependent on tier levels. I am not quite sure how to tie in the number of days the project will take into the formula.

For example: if the project is a Tier 1, then it will be projected complete in 6 weeks from the projected start date. If the project is a Tier 2, then it will be complete in 2 weeks.

Any and all help is appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!