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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
It looks like one of the sheets had the column name changed at some point. You may need to recreate the report.
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@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 😉
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. Good catch! I would have never thought of that.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!