edit values from multiple sheets in one sheet or report

I want to be able to go to a single report or sheet that has different columns from two different sheets and be able to edit the values for both sheets. I tried creating a report that combines two sheets and added the columns i want from both sheets but it's only populating values from one sheet and columns from the 2nd are blank. Is this something Smartsheet is able to do?

Answers