Depending on how complicated this is, you could use a formula.
Automations may be required if there are a lot of different variables involved in the output.
Have a look at the SWITCH() formulas for basic outputs. May have to include IF() and/or AND() etc for more specific conditioning. But if it's too complicated, automations would be easier to set up. Though, it'll be more resource intensive in the long run.
Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/