I have 2 sheets, they are both in the same workspace
Each sheet has a different primary column. Can this be the reason why the new report to pull from the two sheets, is not pulling the data?
I hope you're well and safe!
Can you share a screenshot of the Report and the Filters?
I hope that helps!
Be safe and have a fantastic weekend!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
The primary column in the two sheets will always be used and shown in the report as long as the filter of your report is met by them (despite of their different column names).
You should check your filter.
Gia Thinh Co. - Smartsheet Solution Partner.
The primary column are both account name, on the two sheets.
One sheet pulls the data but the second sheet does not, and the columns are blank.
Do you know why?
Hi Andree - thank you for reaching out.
I ended up doing a workaround by just creating more columns in the one sheet and performing vlookups.
Glad you got it working!
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
I have setup a project intake process that allows the user to submit an Excel spreadsheet via Smartsheet Forms. Data Shuttle extracts the information out of the spreadsheet and adds to my Project Intake sheet. I want the department leader to be able to approve or decline the project and to assign a PM to it. I setup an…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.