Fill up values: Multi Row formula tool does not work?

[HW1]

I am trying to fill up the Site Name column however the formula is not working as it is supposed to.

Formula:

IF ISNULL([Site Name])
THEN [Row-1:Site Name]
ELSE [Site Name]
ENDIF

What am I doing wrong?

Please find example workflow attached.

Thanks

[Qiu · Accepted solution]

@HW1 

I think we need to do a sorting first, to bring the non-null value for site name to top, then the multirow formula will work.

[HW1]

Yep, that works however why would the fill up formula not work?

What you have provided is a fill down solution and I have a use case for a fill up.

Thanks

[atcodedog05]

Hi @HW1 

Fill up wont work because the execution is always top to down. Hence you need to add a record id tool reverse the order so that you can perform Fill down.

Hope this helps 🙂