Can I pull columns in different Sheets in one report as long as Primary Column is the same?
I tried the Community and I came up with nothing. Can I pull different columns in different Sheets in one report as long as the Primary Column is the same?
The columns I need exist in different Sheets, not all Sheets have all the columns. However, the Primary Column is the same (“Interpreter Name” as Text/Number, for example Jane Doe).
For this project, I don’t want to use Copy Rows because I need different things from 4 types of Sheets, by the time I get everything I need, a Sheet will have hundreds of columns.
Since new data will continue to be added to those Sheets, setting up different reports then copy what I need to a data source sheet may require too much manual work than I’d like.
Jane Doe is listed in 2 different Sheets (Primary Column set as Text/Number)
I need the Columns A to F from one Sheet (This Sheet doesn't have Columns I - M ), and Columns I - M from another Sheet (This sheet doesn't have Columns A to F)
I also read about the API approach, can a non Smartsheet Account Admin use API directly?
Thank you in advance.