update a particular row based on the value of previous particular row using multirowformul

[Happylife2025]

Hi , I would appreciate your kind help for solving the issue below. I have the attached data and I want to update record id 4 with the values of record id 2 using multirow formula. Can you please help how to do?

[stataltgee]

@Happylife2025  if u really have to use multirow then below wf will work. Otherwise I'll suggest just update using formula tool for each col 

if [record id] = 4 then 500 else 0 endif 

like this for all columns

[Happylife2025 · Accepted solution]

@stataltgee , thank you so much. if I have 5 more amount columns, is there a way to use one single formula to update all columns instead of using multiple multirow tool?

[stataltgee · Accepted solution]

@Happylife2025  hope this helps