Hi,
I have replica sheets in different workspaces and I am trying to build a roll-up sheet.
Cell linking requires too much manual intervention, so at present I am creating a report.
In the report I need an additional column for 'Client' as the source sheets are client specific and do not have this column. I know that I can include the 'Sheet Name' column to identify the source, but I am looking for just a client name column.
Since I cannot add columns in the report that do not exist in the source sheets, I have tried the following:
I added a hidden column to the source sheet that populates the client name. In order to avoid manual population of this column value, I use a function to populate it based on the primary column having value.
Here is my issue:
The report does not display the values for 'Client' when the source sheet is populated this way.
Any suggestions?