Whitespace in Spreadsheet
When creating logicids, data validation lists, or any logic in the spreadsheet, it's important to avoid inserting spaces at the beginning or end of your fields, as this can cause a variety of problems. So start by investigating if this could be an issue.