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
 10.5K Get Help
 63 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!