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....
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.
Sounds 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 (?)
[Project ID Child]="",[Project ID Video Asset],[Project ID Child]
Is this what you're looking for?
That's it!! Thank you so much! I changed that formula and it's working perfectly now.
What a relief! Thanks again!!