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!

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!