Configure List Layout: Display column based on conditional values from 2 fields

[Ken65]

Hello -

I need to create a column in a list which is the result of one of two values, based on a condition. For example, if I need to show a column which would be drawn from a demand or a project depending on the status, how would the script look to do that. If anyone can point me to an existing post or provide a code snippet, it would be greatly appreciated.

Thanks in advance.

[Chuck Tomasi]

Can you elaborate on what you are doing with some examples and perhaps screenshots/mockups? I'm not entirely clear on the objective.

[Ken65]

My challenge is in ITBM. We had an outside company make a customization. They added a reference of the demand and project tables to the resource plan table. On the resource plan list layout. I would like to have a single column which displays a column value from either the related demand record or the related project record depending on the condition of there being an existing project (or demand only) related to the resource plan. I was looking for scripting to be available on the list layout configuration but it is not looking like there is. 

Thank you

[Chuck Tomasi]

A reference field can only point to single record in a single table at a time. What you might want is a document ID field which can point to a single record in any table. You could potentially script that.