Forum Discussion

Haidarius's avatar
Haidarius
Frequent Visitor
4 years ago
Solved

New column creation

Hello,   So I have tables A,B and C where A and B have a relationship through a column and A has another column with True or blank values I am trying to create a new column using: NEWCOLUMN = IF...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Haidarius 

    maybe you can try this

     

    NEWCOLUMN = IF(RELATED(A[relationshipcolumn])=True(),1)

     

  • parry2k's avatar
    parry2k
    4 years ago

    Haidarius or you don't need to compare value for true, you can further enhance it

     

    NEWCOLUMN = IF(RELATED(A[relationshipcolumn]),1)

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

Haidarius 

maybe you can try this

 

NEWCOLUMN = IF(RELATED(A[relationshipcolumn])=True(),1)