Program Report

Edward H

Hi There,

 

Im trying to create a report on tasks that are programmeed to be undertaken in a specified date range (but not necccesarily starting or finising in that same date range).

 

For example:

 

I have a task that starts on the 1st of February and ends on the 20th February (i.e 21 days of work to complete the task)

I want to be able to run a report that tells me which task are programed to be worked on between 5th February and 10th February.

 

From what I can see I am able to report on task starting or ending between the 5th and 10th February, but the report will not pick up task with durations that 'straddle' those dates.

 

Hopefully this makes sense. Any help would be greatly appreciated.

 

 

Brett Evans

Edward,

I have created a small sheet that allows you to report on work being done in a date range.  You would need to set the date range on the sheet and use the calculation I am doing in the "Include on Report?" column.  When you  create your report, it would select rows taht have a Y in this column.

 

https://app.smartsheet.com/b/publish?EQBCT=5d24cf5b5dd841318c9398bab480a64b

Edward H

Thanks Brett.

 

I think this will work. I will likely create a single 'report settings' sheet then link all other sheets to it, this should allow reporting on all sheets.

 

Thanks for your help.

 

Ed