Calculate bandwidth for 30-60-90 days in the future



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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!