I have two data sources, GameLists and TTDDefects. All my data pulls from GameList and any form data submitted goes to TTDDefects. I am trying to shade in an item in a Gallery once the CompareData text appears on both lists.
I have tried
IsBlank(LookUp(TTDDefectsAll,Compare2 = ThisItem.Compare))),
All my Gallery turns blue, and im struggling to get it to work properly. The compare Data is text not numeric.
Thanks for any help!
@ckserra What Type of column is Compare2? Is it a Textfield? And ThisItem.Compare is also a Text Value?
Could you provide a screenshot of both lists where I can see the Compare2 and Compare Column
@PowerRanger Both columns are also present in different galleries if that makes this easier. Basically if Compare is present in galScroll and galDefect the template fill in galScroll should be red.
@ckserra The formular you have provided looks good to me. Currently I would assume that there is an issue with comparing calculated fields - I can't double check this right now.