What is the best approach to solve the following issue?
Based on a single selection, I want to have predefined prices in another column (default value). But I need the possibility to overwrite the default value for specific single selection items.
With a Formula I can set values, but these values can’t be changed.
You can use a script and automation rule to achieve the goal.
The automation rule can be “If a row is modified, then run the script”. In the script, you can check the value of the single select and set corresponding value another column.