I have three fields with values: ProjectStart, DaysInSprint, and Week. I want to compute a sprint start date and sprint end date based on these values.
ProjectStart = 02 April
DaysInSprint = 7
Week = 1, 2, 3, etc
Formula for Sprint Start should be ProjectStart+(DaysInSprint*Week)
Formula for Sprint End should be (DATEADD({Sprint Start}, 10, ‘days’)
However, I can’t even get the Sprint Start to compute correctly. Any ideas where I am going wrong?
Thanks!
Brad