Posted by gillispie on 4/23/2023 2:51:00 PM (view original):
Posted by trail on 4/22/2023 9:27:00 PM (view original):
Posted by gillispie on 4/22/2023 9:16:00 PM (view original):
probably a 100% sim recruited roster, sim ai can occasionally violate the 13 player rule. i do not believe players can, and its pretty darn rare so seems like you could pretty safely ignore it for your sheet.
also, for the love of god man, post the link or under the ID that has it!
lol well it's fixed now anyway! lmk if you still have any issues knee.
separately, another quick UPDATE
this one isn't sexy but was tremendously annoying. on mobile, if you were searching a time like Illinois or North Carolina, the dropdown would default to any teams sorted ahead of that team in the validation, like Illinois-Chicago. ChatGPT suggested I resort the validation so schools with the shorter names were sorted first and this has fixed the issue! Another win for AI.
pretty cool usage, any chance you have and would be up to share the transcript of that?
ME
hey there - i'm having an issue with this google sheet i built where whenever i go to select a certain value from the data validation dropdown on mobile, it selects another value for some reason. the validation references another tab with school names like "Illinois" and "Illinois State" and for some reason whenever I try to choose Illinois from the drop-down, it selects Illinois State instead. The dropdown works fine on desktop, but this issue crops up on mobile. It prevents you from selecting any school that has alternative schools with a longer suffix, like "North Carolina" vs "North Carolina-Asheville" -- in that case, the former school cant be selected, it reverts to the latter. can you explain why this might be happening and/or ask any questions that might be necessary for you to help me troubleshoot?
GPT
It sounds like the issue you're experiencing may be related to how mobile devices handle autocomplete and/or the dropdown menu in the Google Sheet. One possibility is that when you tap on the dropdown menu, the mobile device may be trying to auto-complete the value based on what you've typed so far, and if there is a longer value that matches more closely to what you've typed, it may be selecting that instead of the value you actually wanted.
To help troubleshoot this issue, here are a few questions:
- What type of mobile device are you using?
- What version of the Google Sheets app are you using?
- Are you experiencing this issue with other dropdown menus in the same Google Sheet, or only with this specific dropdown menu?
- Have you tried clearing the cache of the Google Sheets app on your mobile device and see if that resolves the issue?
- Can you provide more details on how you've set up the data validation for the dropdown menu, including any custom formulae or range references that you're using?
- Answering these questions can help me better understand the issue and provide more targeted advice to help you troubleshoot the issue.
ME
i'm on an iOS device with the latest version of the Google Sheets app. this is the only dropdown im having this issue with. clearing the cache didn't help.
but your auto-complete idea seems reasonable. it always takes the value of the cell that's sorted first in the list (from top to bottom). for example, if you type in Illinois, the following options appear from top to bottom:
Illinois State University
Illinois
Illinois-Chicago
so, in this case, the dropdown reverts to illinois state university even when you try to select Illinois on mobile. I'm using a dropdown (from range) where all schools are listed. would the best course of action be to change the sort on the table so schools like "Illinois" are sorted first?
GPT
Yes, it's possible that changing the sort order of the schools list could resolve the issue. By default, when a dropdown is created from a range, it uses the order of the values in the range to determine the order of the dropdown items. So, if you sort the schools list so that the shorter names (e.g. "Illinois") appear before the longer names (e.g. "Illinois State University"), that should ensure that the correct item is selected when you choose from the dropdown.
To sort the schools list, you can go to the tab where the schools are listed and select the entire range of cells that includes the school names. Then, go to the "Data" menu and choose "Sort sheet by column" (or "Sort range" if you only want to sort a specific range of cells). In the "Sort range" dialog, choose the column that contains the school names as the sort column, and choose either "A-Z" or "Z-A" as the sort order, depending on whether you want to sort the names in ascending or descending order. Click "Sort" to apply the sort.
Once you've sorted the schools list, go back to the cell with the dropdown and try selecting the value again on your mobile device. It should now select the correct value based on the order of the dropdown items.