Vlookup Output doesn't appear in report


I have a sheet that references another sheet to complete the fields via vlookup. However, when a run a report on the sheet, the information populated from the vlookup appears blank? How do I get this information to display in my report?

I have a series of complex sheets that need to be tied together without me having to copy and paste data; I'd like the information to automatically be reported.


Best Answer


  • Elizabeth Jones
    edited 10/06/20

    Thanks! Aha, it was user error. The field names were the issue.

  • Ramzi K
    Ramzi K ✭✭✭✭✭

    @Elizabeth Jones

    I believe the problem is that your report does not have the same fields selected as your sheet. Example: your sheet has a Total Story Points but your report does not. And visa-versa.

    When you say things are appearing blank, they problem is that you did not select those columns in your report.

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!