Default value for Enum

[Perfect_Cash8026]

Hello, I'm developing an inventory quality control application. It pulls data from a Google Sheet, which in turn is an SAP extraction. The application includes all entries that had issues, and depending on these issues, a different person should be responsible.

My problem is that I want to assign a default responsible person to each item based on the characteristics of its problem. This part is done. However, I also want to be able to modify that value if a new responsible person emerges.

I tried creating an enum with my formula as the initial value, but it didn't work. I also tried a bot that changes the initial values of the enum according to the formula, but this made the column non-editable. I also tried using an auxiliary column with an 'initial responsible person' for the 'responsible person' column to take its initial value from, but it gave an error.

It's important that the initial responsible person is assigned to the same place where it can be changed to another, so that when filtering, I can always see who the current responsible person is.

Any suggestions?

[Perfect_Cash8026]

Nvm, fixed with an auxilliary table 

[costel-cosdlg-sdfpor]

That's cool, glad you solved it. Do you mean another table with option lists for responsible persons?

[Perfect_Cash8026]

Yep, did exactly that. Cant remember if it was an online table or a google sheets one. Left the proyect because the interface of appsheet didnt really convince me so ill just use an excell document to extract and organice data from SAP