Help

Automation - update fields with sum of other fields

Topic Labels: Automations Formulas
Solved
Jump to Solution
1873 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jwag
6 - Interface Innovator
6 - Interface Innovator

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!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think if you don't want the helper fields you might need a script for this I'm afraid

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think if you don't want the helper fields you might need a script for this I'm afraid

Thanks Adam, appreciate you confirming what I suspected.