Many Searchable List Items Filter Function

%3CLINGO-SUB%20id%3D%22lingo-sub-3107691%22%20slang%3D%22en-US%22%3EMany%20Searchable%20List%20Items%20Filter%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3107691%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20with%20the%20filter%20function%20to%20create%20a%20searchable%20list%20and%20am%20running%20into%20a%20problem%20where%20if%20I%20delete%20what%20was%20previously%20entered%20into%20a%20cell%20the%20dropdown%20continues%20to%20only%20had%20what%20was%20previously%20in%20the%20cell%20or%20%22not%20found.%22%20If%20I%20try%20to%20update%20the%20cell%20and%20type%20in%20a%20different%20value%20I%20get%20data%20validation%20error%20(green%20triangle%20at%20top%20left%20of%20a%20cell).%20The%20cells%20in%20reference%20are%20in%20column%20B%20of%20the%20%22stakeholder%20register%22%20tab%20and%20are%20highlighted%20in%20yellow.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2F1drv.ms%2Fx%2Fs!Amwn1Oi-aI1xdNY4Bjxi3_GR0_Q%3Fe%3D8c5EOb%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EHere%20is%20the%20file%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3107691%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3107752%22%20slang%3D%22en-US%22%3ERe%3A%20Many%20Searchable%20List%20Items%20Filter%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3107752%22%20slang%3D%22en-US%22%3EHello%2C%20there%20is%20one%20possible%20reason%20for%20this%20it%20is%20either%20you%20have%20to%20restart%20your%20device%20or%20it%20is%20a%20simple%20bug%20if%20it's%20a%20bug%20just%20reopen%20the%20app%20or%20go%20into%20sleep%20mode.%20Thanks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3111978%22%20slang%3D%22en-US%22%3ERe%3A%20Many%20Searchable%20List%20Items%20Filter%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111978%22%20slang%3D%22en-US%22%3EThis%20didn't%20seem%20to%20fix%20the%20issue.%20Could%20it%20be%20anything%20else%20or%20anything%20with%20the%20calculation%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello - 

 

I am working with the filter function to create a searchable list and am running into a problem where if I delete what was previously entered into a cell the dropdown continues to only had what was previously in the cell or "not found." If I try to update the cell and type in a different value I get data validation error (green triangle at top left of a cell). The cells in reference are in column B of the "stakeholder register" tab and are highlighted in yellow. 

 

Here is the file 

 

Thanks! 

 

2 Replies
Hello, there is one possible reason for this it is either you have to restart your device or it is a simple bug if it's a bug just reopen the app or go into sleep mode. Thanks.
This didn't seem to fix the issue. Could it be anything else or anything with the calculation?