Append cell value with previous value and new value from another cell

alishah730

How do we append cell value with existing data.?

for example.

column source and target.

target = target + source.

so every value entered in source it should be appended to target with already existing value in target.

any idea or formula , please help.

thanks

jmyzk_cloudsmart_jp

Hi @alishah730

If you can use a row id or row number, the formula should look like this:😀

=JOIN(COLLECT(source:source, [Row ID]:[Row ID], <=[Row ID]@row), ", ")

https://app.smartsheet.com/b/publish?EQBCT=6eb2314e2764406481662dafbb53c1f7

alishah730

its creating new row.

i need its to be in the same row.

whatever being added to to source cell should be appended to target.

source can be cleared but target should contain with all the values entered in sources.

last entered data in source is entering loop 4 , target has all the three previous entry along with latest entry from source

jmyzk_cloudsmart_jp

@alishah730

In such a case, I would use copy rows automation and the Row ID to get the source cell records from the copied sheet.

https://app.smartsheet.com/b/publish?EQBCT=f29fa0624d624ecdbb030da753c90d7f

Cell History Shows the changes in the source cell in row 3.

DdLund

Hello, in addition to question/answers above, are you aware of a way to place the appended value at the start of target cell, rather than at the end of cell contents? Thank you.