Reporting on columns

pworth@jacksonprop.com

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!

Genevieve P.

Hi @pworth@jacksonprop.com

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

Paul Newcome

It looks like one of the sheets had the column name changed at some point. You may need to recreate the report.

pworth@jacksonprop.com

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?

Genevieve P.

Hi @pworth@jacksonprop.com

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

pworth@jacksonprop.com

@Genevieve P. Thank you... rookie mistake ~ face palm😂

Genevieve P.

Haha no problem at all! I've done that countless times, which is why I knew to ask 😉

Paul Newcome

@Genevieve P. Good catch! I would have never thought of that.