Reporting on columns
Hi,
i am trying to create a report based on user from multiple sheets. The report was working just fine about a month ago and now its not picking information correctly. I named the 2 columns in my sheets the Asset Type and I need the report to grab information based on user name so it becomes one column and my hardware and software aligh with the user name
thank you!
Best Answer
-
Have you checked the column type as well?
If one sheet has the column as a Text/Number type of column and the other has it as a Dropdown list, they'll appear as separate options. You'll need to ensure the column type matches as well as the name.
I hope that helps!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
It looks like one of the sheets had the column name changed at some point. You may need to recreate the report.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Nope... still not working corretly. I was almost positive that if you name columns in 2 seperate sheet the same the report will grab the information under one column not 2. User name and Asset type are twice... oh what am i missing?
-
Have you checked the column type as well?
If one sheet has the column as a Text/Number type of column and the other has it as a Dropdown list, they'll appear as separate options. You'll need to ensure the column type matches as well as the name.
I hope that helps!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. Thank you... rookie mistake ~ face palm😂
-
Haha no problem at all! I've done that countless times, which is why I knew to ask 😉
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. Good catch! I would have never thought of that.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!