I want to understand why my conditional formatting is only working some of the time.
I have my calculation looking for a exact text string in a related table record.
RelatedTable::Related field = "Text"
I am looking into the related table through a portal and adding records via a button.
If I add the record containing the 'Text' before any other record the conditional formatting works. But if I've added a different record prior to adding the one containing 'Text' it doesn't apply the condition.
I want the condition to apply no matter when the record is created or if it exist with other records.
Is there something simple I am overlooking.
Sorry for the newb question.