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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!