You can use:
IF({When was this added}="Quarterly Planning", SWITCH( {Estimated size},"Small (2-4 weeks)", DATEADD({Target in market date}, "-35", "days"),
"Medium (4-6 weeks)", DATEADD({Target in market date}, "-49", "days"), "Large (6-8 weeks)", DATEADD({Target in market date}, "-63", "days")))
ps: use the right field name for {When was this added}
You can use:
IF({When was this added}="Quarterly Planning", SWITCH( {Estimated size},"Small (2-4 weeks)", DATEADD({Target in market date}, "-35", "days"),
"Medium (4-6 weeks)", DATEADD({Target in market date}, "-49", "days"), "Large (6-8 weeks)", DATEADD({Target in market date}, "-63", "days")))
ps: use the right field name for {When was this added}
Thank you so much, this worked!
Is there a way to add onto this formula to return the created date if "When was this added to the Plan?" does not equal "Quarterly Planning"?
Current Formula:
IF({When was this added to the Plan?}="Quarterly Planning", SWITCH( {Estimated size},"Small (2-4 weeks)", DATEADD({Target in market date}, "-35", "days"),
"Medium (4-6 weeks)", DATEADD({Target in market date}, "-49", "days"), "Large (6-8 weeks)", DATEADD({Target in market date}, "-63", "days")))