I have just started using SharePoint lists. I assume my issue is simple but I cannot find a solution for it anywhere so I am asking you.
I have been developing sharepoint list for few days. I just need it for one project so I am looking for the simplest solution possible.
I need sharepoint to give suggestion when inserting new data into column based on the column contents. Just like excel does by default. E.g. so if I type "Bob" sharepoint would show me suggestion "Bob Andrew" (assuming that Bob Andrew is already in the column), if I add "Bob R" it would show me suggestion "Bob Richards"(assuming that Bob Richards is already in the column). Obviously newly entered values should also appear in the future suggestions.
I would appreciate any help how to achieve this.