Help with a formula please

Hello! I've been trying to figure this out for a good part of the day and am at the end of my rope. I could use some help please.... Three fields: Project ID Project ID Video Asset Proj...