Calculate bandwidth for 30-60-90 days in the future
Hello-
I am tracking employees' bandwidth assigned to multiple projects. I use a start and end date plus their % of time allocated. I need to show their total bandwidth at 30, 60 and 90 days to forecast resources. What formula can I use to show their current bandwidth (Today), 30 days, 60 and 90 based on the start and end date range. Thank you.
Answers
-
Are you able to provide some screenshots of sample data manually filled out to show exactly what you are wanting to automate?
-
This is what I currently have but in Google Sheets. I'm trying to show bandwidth over time as projects start and stop so we can forecast resources. The data are the individual project entries. The yellow shows it aggregated. Thank you for your help!
-
How is your data currently structured in Smartsheet, and are you wanting these calculations on a different sheet or the same sheet as the source data?
-
Right now I don't have any data in SS for this. I plan to have these calculations on the same sheet, similar to how it is in the screenshot.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!