# Add value of cell to another cell **URL:** \ **Category:** Ask the Community\ **Created:** [May 6, 2024, 5:37am UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460 "2024-05-06T05:37:54Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Isebar\_DE](https://avatars.discourse-cdn.com/v4/letter/i/6bbea6/32.png) [@Isebar\_DE](https://connect.superhuman.com/u/Isebar_DE)\ **Post date:** [May 6, 2024, 5:37am UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/1 "2024-05-06T05:37:54Z")
Hi community, How can i add the value in column “new value” to column “all values”, every time i modify “new value”? The Doc: https://coda.io/embed/txPjNV1kAW?viewMode=embed ---
**Author:** ![Jannis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jannis/32/34283_2.png) [@Jannis](https://connect.superhuman.com/u/Jannis)\ **Post date:** [May 6, 2024, 9:27am UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/2 "2024-05-06T09:27:15Z")
Hi @Isebar_DE, Basically, there are two solutions for you: 1. Using a button (my recommendation) 2. Using an automation For the modification, you can use the [ListCombine() formula](https://coda.io/formulas#ListCombine), but this is definitely not the best method as you have to manually add the newly added values ​​to the select list. If anyone else has a different approach, I would be grateful to share it. Jannis ---
**Author:** ![Isebar\_DE](https://avatars.discourse-cdn.com/v4/letter/i/6bbea6/32.png) [@Isebar\_DE](https://connect.superhuman.com/u/Isebar_DE)\ **Post date:** [May 6, 2024, 4:33pm UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/3 "2024-05-06T16:33:56Z")
@Jannis thanks once again! Since i need many, don’t wnt to do it via automation yet. Button method is ok. If anyone has a better idea, please let me know. ---
**Author:** ![joost\_mineur](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joost_mineur/32/30539_2.png) [@joost\_mineur](https://connect.superhuman.com/u/joost_mineur)\ **Post date:** [May 6, 2024, 10:48pm UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/4 "2024-05-06T22:48:05Z")
Your sample has a problem that looks like the issues in your other doc: different types of values in your columns. Assuming you don’t want duplicates, I put an automation in your doc to react on new entries in the column new value. I made the column a relation column - if you want a new item, you need to add it to your values table, which is straight forward as coda makes the suggestion to add it while entering the New Value. Th column All Values is a select list - just to show you what is possible. It could have been a text field, which can hold objects too. You can use the solution I show in your other doc to not allow any value that’s already in the other column. The changes are in your document. ---
**Author:** ![Isebar\_DE](https://avatars.discourse-cdn.com/v4/letter/i/6bbea6/32.png) [@Isebar\_DE](https://connect.superhuman.com/u/Isebar_DE)\ **Post date:** [May 7, 2024, 7:23am UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/5 "2024-05-07T07:23:42Z")
Thanks. For now i keep the button method, but doing it via automation will be the next step. ---
**Author:** ![Isebar\_DE](https://avatars.discourse-cdn.com/v4/letter/i/6bbea6/32.png) [@Isebar\_DE](https://connect.superhuman.com/u/Isebar_DE)\ **Post date:** [May 10, 2024, 9:07am UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/6 "2024-05-10T09:07:26Z")
Hey @Jannis , I just figured, that there is an issue: The first column is not a multi select list. So there is always only one value selected. Now when i press the button, the other values in the “All Values” column get deleted. But it should add the new value to the existing values. Check: https://coda.io/embed/txPjNV1kAW?viewMode=embed ---
**Author:** ![Jannis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jannis/32/34283_2.png) [@Jannis](https://connect.superhuman.com/u/Jannis)\ **Post date:** [May 10, 2024, 9:39am UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/7 "2024-05-10T09:39:47Z")
Hi @Isebar_DE, I just modified the formula. Please check if everything is working now as expected. Jannis ---
**Author:** ![Isebar\_DE](https://avatars.discourse-cdn.com/v4/letter/i/6bbea6/32.png) [@Isebar\_DE](https://connect.superhuman.com/u/Isebar_DE)\ **Post date:** [May 10, 2024, 7:47pm UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/8 "2024-05-10T19:47:26Z")
Think this is the solution. Thanks mate. ---
**Author:** ![Jannis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jannis/32/34283_2.png) [@Jannis](https://connect.superhuman.com/u/Jannis)\ **Post date:** [May 10, 2024, 7:55pm UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/9 "2024-05-10T19:55:56Z")
Okay, great! Have a nice weekend, @Isebar_DE. Best regards Jannis EDIT: Here is a video from Scott of the method I used: [![](https://global.discourse-cdn.com/coda1/original/3X/3/0/305bec10a2d72eb0912b5b9cff987bd6143aeea1.jpeg "Modifying multiple select lists is harder than you think") ](https://www.youtube.com/watch?v=DzZsVyMINgE) ---
**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\ **Post date:** [May 13, 2024, 7:56pm UTC](https://connect.superhuman.com/t/add-value-of-cell-to-another-cell/48460/10 "2024-05-13T19:56:09Z")
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.