Overwrite default values

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.

Any ideas?

Thx in advance

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.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.