User input formula field
Is there a way to create a field/column that is a required field, user input and formula field at the same time (without using automations or pipelines)?
The scenario is I have 2 columns:
Column 1 is a required & user input field.
Column 2 is a formula field.
If column 2 has value then column 1 can be left empty
OR
If column 2 has value, copy value to column 1 only if it is empty (since it is a required field)
Or do I not have choice but to manually input a value in Column 1?
The scenario is I have 2 columns:
Column 1 is a required & user input field.
Column 2 is a formula field.
If column 2 has value then column 1 can be left empty
OR
If column 2 has value, copy value to column 1 only if it is empty (since it is a required field)
Or do I not have choice but to manually input a value in Column 1?
