How to fill down values to the row below in the same column?

hi Guys,

this is my second attempt to get some help around what is the best way to fill down from a field to the row below.And other way around. I believe that multi-row formula, 'overwritng existing field' function would do but I was not able to figure out the IF statement correctly for that.

Attached my dataset.

The task is a basic data-true up where I need all lines related to source B to look like as it looks in source A. Except if some fields related to source A are blank,then copy from source B. Important that the dataset remains in the same order based on the record ID. Also, there are much more columns in my original dataset that I cannot disclose, but the logic should apply to those columns too.

Can someone take a look into it?

I would really appreciate the help.

regards,

MateK

overwrite test 1.xlsx

Datasets

Accepted answers

RolandSchubert

I've modified the formula, but - if you say, always copy A to B, the value for RecordId 3 would be 79758463 (as this is the value for source = A). I changed the formula according to that "set A = B" requirement, but it can be reversed easily. Let me know if it works as expected.

MultiRow.yxmd

All comments

RolandSchubert

Hi @EtamSoko ,

I've created a workflow using the Multi-Row Formula tool, hopefully it is helpful.

Best,

Roland

MultiRow.yxmd

EtamSoko

hi Roland,

thanks for your quick response.

However, it still does not function well, maybe I was not explaining the needs, apologies.

So basically what I would like to achieve is to copy down from all rows from source line A to B unless A is blank. If you take a look at record ID number 3, in the row for source B in serial column I would like to see 079758463, in record ID number 4, 069447038, etc. basically making a copy from all rows from source A to B.

The part for IF Null, that works perfectly.thanks!

would you be able to help me still?

thanks a lot in advance.

MateK

RolandSchubert

MultiRow.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703