Self-updating report based on sheets in folder
Is there a way that I can build a report so that when a new sheet is added to a smartsheet folder, the contents of the sheet then automatically gets compiled into a report?
I saw that it was possible to select a folder when building a report, which I was really hoping would have that functionality. But it looks like it just takes a static view of what is in the folder at the time of originally selecting it.
Alternatively, can I write a formula or cell reference that would automatically reference a new sheet? (Can use tools such as zapier to input a formula on a row once a new sheet is created).