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!
Answers

Try a nested IF similar to this:
=[Projected Start Date]@row + IF(Tier@row = 1, 42, IF(Tier@row = 2, 14, .....................)))

Thank you @Paul Newcome!
Having some trouble still  here is the exact formula I have, but it's still showing as unparseable. I have tried moving parentheses around, but still no luck. Any advice?
=[PROJECTED START]@row + IF([TIER LEVEL]@row = I, 60, IF([TIER LEVEL]@row = II, 25))

If you are using roman numerals in the tier level column, those are treated as text values and should be wrapped in quotes.
=[PROJECTED START]@row + IF([TIER LEVEL]@row = "I", 60, IF([TIER LEVEL]@row = "II", 25))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!