Create a report from multiple sheet but with row as Columns
I am trying to make my Smartsheet work better for my user. the problem that I am facing id the following
My Workspace is build in the following way. Each of our project have a specific folder name let say Project1 , Project 2, Project 3
In each of that folder we have many many files, one of them there is a sheet called Project - main sheet that user update on a daily basis
the sheet look like this and have the same format in each folder
The issue that we are facing is that in order to update the data they need to enter the specific folder Open the specific sheet update it ... it takes tons of time
We would like to create a report where each row is the Sheet Name, the columns are the SCC MetaData Fields and the value to input, the text value
How can I achieve this ?