Need help with a formula that will pull info from 2 sheets.


Hi, I have my comprehensive sheet. Its currently pulling status info from a photography sheet. When photography is done with a project (each project has its own row), the project(row) gets archived to another sheet. When achieve, the current status of the project is no longer on the comprehensive sheet.

So currently I can see the status change from the photo sheet on the comprehensive sheet. Need to be able to still see the "Complete" status when project(row) is archive.

So I'm think I need a formula that can pull from both sheets?

Current formula: =IFERROR(INDEX({Status}, MATCH([PRODUCT NAME (WF)]@row, {Title OW}, 0)), "")

How can I pull the same info, if the first sheet doesn't have it?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!