Can I add drop down list (with data from a list) to cells that are loaded with data?

Options
wjackm
wjackm Member, ALL USERS Posts: 5 New Contributor

Can I add drop down list (with data from a list) to cells that are loaded with data? I've added a validate button, but now I'm trying to create a functionality that allows managers to make changes to data if the loaded data is incorrect. I'm having trouble including both a drop down list and prepopulated data in the same cells though and I can only figure out how to do one or the other. Any tips would be greatly appreciated.

Comments

  • wjackm
    wjackm Member, ALL USERS Posts: 5 New Contributor
    I took this idea and tweaked it and it worked well. I created a box that can be checked if there is an error, which unlocks the drop downs for a new set of columns where corrected data can be input. Final data is pulled from the new set of columns unless they are blank (meaning there was no error), in which case data is pulled from the original columns. Thank you!