Hi there,
Hoping someone can help with something I hope can be automated.
I have multiple fields with numbers in, let's say:
Field 1A: 100
Field 1B:
Field 2A: 250
Field 2B:
Field 3A: 500
Field 3B:
I then have a % field, based on which I would like an automation to populate the 'B' fields (as a % of the 'A' fields), when the % field is updated. The reason I would like to do this as an automation rather than formula is that I would like the B fields to be editable to allow for bespoke amounts. Usually, the % will be the same for all B fields (there are around 10), but not always. Therefore, if I enter 10% in the % field, the numbers will populate as follows:
'B' columns as % of 'A' columns: 10%
Field 1A: 100
Field 1B: 10
Field 2A: 250
Field 2B: 25
Field 3A: 500
Field 3B: 50
The only way I can think to do this would be to have a formula field for each one that sums the % by the 'A' field, then a manual override field, then an if formula that says "if({override field}="",{sum field},{override field})".
As there are multiple fields to this for, I'd prefer to avoid adding so many helper fields.
Is it possible to automate this?
Many thanks in advance!