FIRST ROW VALUE TO PASTE TO ENTIRE COLUMN

[RD32XU]

I am trying to copy the first row value and paste it to whole column using below formula. However, for some reason it's not working. Can someone help me? Thank you.

if [RecordID] = 1
then [Book date]
else [Row-1:Book date]
endif

[atcodedog05]

Hi @RD32XU 

Instead of multi-row formula you can use this approach. Filter the first row and append it.

Edit: For fixing the formula you can use @clmc9601 method. This method hit my mind first hence I went with it 😅 now you have 2 methods for the usecase 🙂

Hope this helps : )

[clmc9601 · Accepted solution]

Hi @RD32XU,

Just a simple change to your formula will also work:

if [RecordID] = 1
then [Book date]
else [Row-1:maxdate] // use the name of the column that Multi-Row is creating
endif

[HomesickSurfer]

Hi @RD32XU 

Another variation is to use a summary tool to identify the First record value, then append to ALL...then clean up.

Workflow attached.

[HomesickSurfer]

Hi @clmc9601 

I am uncertain if @RD32XU wants the MAX date, rather instead the first records' value that incidentally IS the max in the set.

[RD32XU]

Thanks everyone, works fine. Both solution above able to get the output I want which is to copy first raw value to entire column.

if [RecordID] = 1
then [Field1]
else [Row-1:maxdate]
endif

[RD32XU]

Thank you for this. 

[atcodedog05]

Happy to help : ) @RD32XU 

Cheers and have a nice day!