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!
spipmo
Answers
-
Try this:
=INDEX([Column4]@row:[Column8]@row, [Column2]2)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
-
How exactly is [Column2]2 being populated?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hello @Paul Newcome
[Column2]2 value based on project current duration, days
say current duration is 361 days, 361days / 7days = Week no. 51
Thanks
-
Are you using a formula or is it manually entered? If it is a formula, can you copy/paste the exact formula here?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hello @Paul Newcome
Here's are formulas that I'll use to get the Week no & Period (date) based on project duration / dates
Thank you!
-
Did you change that last [Column2]2 reference to [Column2]4 after inserting those two rows at the top?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
yes, to show how week # changes based on current duration. current duration is 32 days -- it falls under week no 5
so the Target % to date will sum up the values from week 1 to week 5 (the formula for this am up to -- my interim solution will reach it limit if weeks
-
So this is the formula you have in the Target % to date column?
=INDEX([Column4]@row:[Column8]@row, [Column2]4)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!