Help with a formula please

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

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!!

Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb

Hi

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 (?)


If(

[Project ID Child]="",[Project ID Video Asset],[Project ID Child]

)

Is this what you're looking for?


Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb
Hi - I'm looking for the latter, but that formula returns the same result that I was getting with the other formulas.  
Thanks for your response! 
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
Are any of the fields involved marked to be "unique"?
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
Oh i take that back.  Whatever formula you have in the "Formula Child" field is inserting a hyphen (-).  So it is never empty,  thus your next field is not what you'd expect.

What is the formula for the child formula field? 

Fix that and you should be good.
Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb

That's it!! Thank you so much! I changed that formula and it's working perfectly now.

What a relief! Thanks again!!