Hello There,
I need to be able to help my fellow colleagues out with this table:
Our folks want to be able to quickly define what ID number does a given task have, based on a free text entry where the formula is looking for that specific text string in the other columns containing descriptions and further details and such.
The best way to visualize the resulting ID number of that task would be to either:
a; list all the task ID numbers where that text string has been found
b; highlight those cells or rows where that text string has been found
Example:
the user inputs into a search dialog box(?): 'jump'; rows ID number 1 and 2 would be highlighted, or at least all cells/words containing 'jump';
the user inputs into a search dialog box(?): 'under'; row number 3 would be highlighted or at least all cells/words containing 'under'
the visualization is important since I want to ensure that the user has a freedom of choice which ID numbers to choose; or if it would be possible to use multiple comma separated keywords like: 'jump, fox' then only row ID number 1 would be highlighted since row ID number 2 doesn't contain 'fox' - this would be awesome
thank you if you can help me out.
Is it maybe easier to do this in PowerBI I'm wondering right now?
Bookmarks