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?


  • Genevieve P.
    Genevieve P. Employee Admin

    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.