Combine two sheets to one report


Hi Team

I am trying to combine two sheets into one report.

Have added the two sheets. But wondering if it is feasible to combine the two sheet columns and data into one where the data can sit against the common Project name vs below.

The Project nomenclature is the same on both sheets. Trying to see if we can have the desired result.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!