Dynamic multi-row formula based on field names

[jnn073]

Hi there,

Below is my data set and I want to update columns ending "Total Value" with a formula that multiply columns ending "Number of shares" and "Share price". I  assume we need to use Multi-row Formula, but not sure what functions to use so that it would match the Award number in calculating the Total value. Many thanks in advance.

	Award 1 Number of shares	Award 1 Share price	Award 1 Date	Award 1 Total Value	Award 2 Number of shares	Award 2 Share price	Award 2 Date	Award 2 Total Value	Award 3 Number of shares	Award 3 Share price	Award 3 Date	Award 3 Total Value
Person A	100	$5	5/06/2019		200	$7			50	$4
Person B	200	$6	6/01/2019		100	$5			100	$7
Person C
etc.

[fmvizcaino · Accepted solution]

Hi @jnn073 ,

Attached is a workflow that does the job you need.

Let me know if that works for you.

Best,

Fernando V.

[jnn073]

Thanks so much .@fmvizcaino!