Information Coming from Two Sources

Hello, Smartsheet Control Center Group!

I want to ask a question regarding auto-filling out a cell coming from two sources. Either from the intake sheet or the project plan. The receiving sheet is the metadata sheet. Currently, it will only work if the information is coming from the intake sheet. Please help.