multi row formula with multiple conditions

[BosKev]

Hi All,

I want to create a field that will be able to tell me whether a employee has met the target or not in a trended timeline

in the example below I want to recreate the [met] field, the first time they met the running total of "40=>" then create a "yes" indicator" but only once to show which week that person hit the goal.

I tried the multi row tool not sure how to tell the tool to stop labeling "yes" continuously. Thanks.

Names	Week	Running Total	Met
Kevin	1	10
Kevin	2	20
Kevin	3	30
Kevin	4	40	Yes
Kevin	5	50
Dave	1	20
Dave	2	40	Yes
Dave	3	60
Dave	4	80
Dave	5	100
Amy	1	40	Yes
Amy	2	60
Amy	3	80
Amy	4	100
Amy	5	120

[AngelosPachis · Accepted solution]

Hi @BosKev ,

You can do that with a combination of the formula and multi-row formula tools

Hope that helps,

Cheers

Angelos

[BosKev]

Thank you so much!