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

wjackm

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.

JaredDolich

@wjackm 

Love this idea. So one way you might consider approaching this is to validate the line item with another line item. If the validation indicates an incorrect entry then use DCA to open up another line item that gives an error message based on the rules you establish. DCA can be used to make text invisible, readable, and editable. You can even make a final value locked until the error is corrected.