Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

View Multi-Day Tasks in a Report Grouped by Day

I have built a scheduling tool in Smartsheet for my Team to track standard, ad hoc, training, and PTO. I have setup a report that pulls scheduling data from multiple sheets with tasks grouped by start date. I use this report to see how my Team is scheduled during a given week.

Unfortunately, in this report, tasks that occur over multiple days (e.g., training or PTO) only show up in the grouping for their start date (makes sense per grouping rule). Is there a way to setup my grouping so it shows the task each day it occurs? A different grouping type or maybe a column in the data sheet that captures multiple 'start dates' based on the task duration?

Answers

Trending in Smartsheet Basics