Reporting on columns



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

  • Genevieve P.
    Genevieve P. Employee Admin
    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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!