Text Formula Field with Filtering Criteria
Hello, Can anyone provide some help with a formula for this? In my tasks table, I have 3 lookup fields: , [Properties - Address], and [Projects - Address]. When creating a report of a user's tas...
Forum Discussion
Josh,
First make sure that the reference field for each parent reference field has the Blank box cleared.
Create a Formula Text field called Absolute Address
If (
IsNull([Related Transactions] )=false, ToText(),
IsNull([Related Properties])=false, ToText( [Properties - Address]),
IsNull( [Related Projects)]=false , ToText([Projects - Address]), "Error, No Parent Transaction, Property or Project" )
This sequentially goes through your Parent relationships, checks if it exists and converts the Look Up Address to a Text Field.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
First make sure that the reference field for each parent reference field has the Blank box cleared.
Create a Formula Text field called Absolute Address
If (
IsNull([Related Transactions] )=false, ToText(),
IsNull([Related Properties])=false, ToText( [Properties - Address]),
IsNull( [Related Projects)]=false , ToText([Projects - Address]), "Error, No Parent Transaction, Property or Project" )
This sequentially goes through your Parent relationships, checks if it exists and converts the Look Up Address to a Text Field.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------