Announcements
Hey guys,
currently I'm doing a lookup function that is properly working if I use one condition but if I try to put a second one it gives me error.
IsBlank(LookUp(collectionLead,Platein CollectionLeadTemp.Plate&& collectionLead.'Status Plate' = "Open"))
How can I manage it?
Hi Sesese,
Just a thought: could it be collectionLead.'Status Plate' is a choice column? If so, try:
IsBlank(LookUp(collectionLead,Platein CollectionLeadTemp.Plate&& collectionLead.'Status Plate'.Value = "Open"))
Marc
Hi @Sesese ,try this
IsBlank(LookUp(collectionLead, Plate in CollectionLeadTemp.Plate And collectionLead.'Status Plate' = "Open"))
Accepts this as a solution if it works for you
Putting "=" before "Open" it gives me error, it says Incompatible types for comparison using table and text
Don't know why
Hi @Sesese ,
Just curious: did you try
IsBlank(LookUp(collectionLead,Plate in CollectionLeadTemp.Plate&& collectionLead.'Status Plate'.Value = "Open"))
Is it probably because I'm looking on the first part at data on another collection & in the second part at value on the same collection?
In the first collection I can have multiple rows with same value
I need that at least one i s"Open"
Then @Waegemma's suggestion best fit the scenario.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 339 Super User 2026 Season 2
M Bilal Khan 289
Mohsin Ali 228
