Weird Thumbnail appears beside selection on dropdown list When using Valid if

when i use Valid if to limit my drop list to certain values i found the icon shown in the photo
3X_1_e_1e0302c8fc1325dc9deabdc2208912a1f6c70cf7.png

However, i used the ref type with other dropdown list without any valid if statement, and it works perfectly.

The Expression used in the valid if part is :

Blockquote

SELECT(SUBMITAL NO[Submittal No],
AND(
[Project_id]=[_THISROW].[Project],
[Submittal Type]=[_THISROW].[Submittal Type],
[Discipline]=[_THISROW].[Discipline]
)
)

as shown in the photo:

Am i doing any thing wrong? how to get rid of that icon?

Solved Solved
0 11 286
1 ACCEPTED SOLUTION

You would need to create your expression so that you select Engineers who have projects - i.e. a filtered list of Engineers.

Something like this:

SELECT(Engineers[Engineer ID], IN([Engineer ID], Projects[Engineer]))

In english - โ€œSelect the Engineer ID from the Engineers table where the Engineer ID is IN the list of engineers from the Projects tableโ€

NOTES:

  • Projects[Engineer] is short-hand for 'SELECT(Projects[Engineer], TRUE)`
  • This assumes that [Engineer] is a REF column to the Engineers table

You can read more about the IN() function here:

View solution in original post

11 REPLIES 11
Top Labels in this Space