Anyone who has an alternative formula for this?
I need the Target % to date column to sum up the values of each activity based on week no (red font). For now i use this formula (see sample data below) as interim solution, problem is the formula will reach the limit if i have more than 30 weeks (usually we set 100weeks in projects).
Thanks you in advance!
Help Article Resources
Check out the Formula Handbook template!