Dropdown List Per Cell Using API?
I have been doing a ton of research on how to do a dropdown at the CELL level, instead of column level. All signs point to this being a lost cause, as the feature has been being requested for 5+ years now.
However, one forum response indicated this is possible through API. Does anyone know if this is the case? If yes, how do I make that happen?
If no, are there any other workarounds to make this possible?
Answers
-
Hi @TechTeam
If I'm understanding you correctly, you want to have different dropdown options appear per-cell in the same column. This currently isn't possible, via the UI or API - dropdown list options are set for the entire column.
I believe the post you are referring to where API is suggested was for a different functionality (updating dropdown lists based on a different sheet's data).
Depending on your use-case, you could set up multiple columns with your different selections then show the relevant ones via a Form (with logic set up), and in the source sheet have one "master" column where the final selections appear, using a formula.
Cheers,
Genevieve
