Updating Values on entire row(multiple columns) based on condition?

[Aviator0807]

I want to zero out the row where Product 4 is. Is there an easier way to do it this, instead of creating 4 different field formulas for each column? 

ex.

Output: Store A

IF [Product] == 'Product 4' Then 0 ELSE [Product] ENDIF

Output: Store B

IF [Product] == 'Product 4' Then 0 ELSE [Product] ENDIF

Output: Store C

IF [Product] == 'Product 4' Then 0 ELSE [Product] ENDIF

Output: Store D

IF [Product] == 'Product 4' Then 0 ELSE [Product] ENDIF

Product	Store A	Store B	Store C	Store D
Product 1	10	25	40	50
Product 2	10	25	40	50
Product 3	10	25	40	50
Product 4	Null	Null	Null	Null

[atcodedog05 · Accepted solution]

Hi @Aviator0807 

This can be achieved using multi-filed formula tool.

Workflow:

Hope this helps : )

[MatthewBr]

@atcodedog05  beat me to the punch. This is what multifiled formula is for. 

@Aviator0807  - Remember to mark as complete if the solution provided solves your challenge!