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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!