KarenHenke
8 years agoQrew Cadet
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
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!!