when i use Valid if to limit my drop list to certain values i found the icon shown in the photo
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! Go to 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:
You can read more about the IN() function here:
User | Count |
---|---|
16 | |
12 | |
9 | |
4 | |
2 |