Reports-Data from single cell/row from multiple sheets
Brand new to smartsheets.
When I run a report, it grabs all the data from multiple sheets and the entire column of each sheet. This makes the report have 10+ rows for each sheet, when I want one row from each specific sheet .
Is there a way to define what row I want to report? I would like to be able to run a report on one row, and adjust the start dates. This way I can plan each project back to back in a gantt chart without having to go to each sheet individually.
The yellow cell is the main date that I want to be able to adjust in a report, for each job. This way I can schedule what job comes after which one, and pull more resources if I find an issue with scheduling.
Thank you very much,