Hi all, needed some help with an app. Need to get data in a column from another sheet based on whether the value of two columns is the same.
I’m using this in the Valid_if space:
SELECT(Collection[Customer Name], [FSE Phone Number]=[_THISROW].[Phone Number])
However this is making the column itself disappear from the form. Can anyone help me? I’ll share the sheet & the app in replies to comments.