2 sheet - 1 report

MLo

I created a report taking data from 2 sheets. The formats and drop-down menus are correctly captured from sheet 1 but not from sheet 2.
I also noticed that the column "sheet name" was created only for sheet 1 but not for sheet 2. I created the initial report with sheet 1 and only after added the sheet 2 to the same report.
The 2 sheets are having the same primary column with unique numbering and I want the data from the 2 sheets to appear in the same line (different columns)
Can you help me understanding why and correct the report?

Andrée Starå

https://community.smartsheet.com/discussion/140811/2-sheet-1-report

Hi,

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing)
That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏