Help with a formula please

Question

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
Project ID Child

I would like the Project ID field to display the Project ID Child field. If Project ID Child is blank, I would like it to display Project ID Video Asset.

These are the two formulas I've tried without luck:

If ([Project ID Child] <> "", [Project ID Child],
[Project ID Video Asset]<> "", [Project ID Video Asset])

If ([Project ID Child]<> "", [Project ID Child], [Project ID Video Asset])

I'm including a screen grab of the results that both of these formulas return.

Please let me know if you need any additional info in order to assist.

Thank you!!

ChrisChris · Answer

HiSounds like you want Project ID Child to be the 'proxy' of Project ID. Is this correct? As far as I know, you cannot create a 'co'-proxy field. I may be wrong, but I do not think you can.If the above is not the case, then it seems you want Project ID child to take precedence over project ID Video Asset (?)If([Project ID Child]="",[Project ID Video Asset],[Project ID Child])Is this what you're looking for?

Sign up

Login to the community