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] = 1then [Book date]else [Row-1:Book date]endif
Hi @RD32XU,
Just a simple change to your formula will also work:
if [RecordID] = 1then [Book date]else [Row-1:maxdate] // use the name of the column that Multi-Row is creatingendif
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 : )
Another variation is to use a summary tool to identify the First record value, then append to ALL...then clean up.
Workflow attached.
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.
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] = 1then [Field1]else [Row-1:maxdate]endif
Thank you for this.
Happy to help : ) @RD32XU Cheers and have a nice day!
