Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
8 years ago

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

Formulas and functions

5 Replies

  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    8 years ago

    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?


  • KarenHenke's avatar
    KarenHenke
    Qrew Cadet
    8 years ago
    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! 
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    Are any of the fields involved marked to be "unique"?
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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.
  • KarenHenke's avatar
    KarenHenke
    Qrew Cadet
    8 years ago

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

    What a relief! Thanks again!!