Row Lookup

Options

I have multiple project sheets with row items that are the same on each sheet and each row has a percentage of completion. I am trying to create a new summary sheet that has each row item as a column and return the percentage of completion. ie: row items "excavation, framing" etc. are column headings on the new summary sheet with corresponding completion percentage populating from the rows on the project sheets so we can see which projects are excavated, framed etc. Is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!