Copy New Values from 1st Column to Add in Accumulative 2nd Column

DataLime

Hi, I have set of values in 1st Column (single select). When the person comes in and he select any value, I want this value to go in 2nd column and add in previous value of 2nd column. Say if it was 0 initially and person selected 5 in 1st column, it shall be 5 in 2nd column. And if he again login to sheet and select 10, it shall show 15 in 2nd column.

So far I have added two automations. One automation immediately copies the value from 1st column and paste into another column (say 3rd column) and second automation then deletes the value in 1st column so if person comes again he can select new value. And then I'm confused how to achieve what I wrote in above paragraph? Can anyone help me out? Thanks

DataLime

@Paul Newcome may I request your kind assistance please. Thanks.

DataLime

@Andrée Starå kindly help me out with this. Thank you.

Andrée Starå

Hi @DataLime

I hope you're well and safe!

Are the values set stages, or can they be anything from 1 to infinity?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

DataLime

Hi @Andrée Starå first of all I'm thankful to you for responding to my query.

Although I have just achieved what I was looking for but I would like to explain here for any suggestions.

I have three columns as follows:

1. Primary Column: Key Identifier or Row ID (already defined against each task)
2. 1st Column (single select): Time Spent in Sheet using pre-defined values (10, 20, 30.. until say 100)
3. 2nd Column: Total Time Spent

Step 1: User comes in the sheet and selects time spent in sheet using pre-defined values in 1st Column.

Step 2: As per automation, row will be copied to another sheet that runs when 1st Column value is changed to any pre-defined value

Step 3: User login to sheet again and change value in 1st Column, the same automation runs again

Step 4: SUMIFS formula in main sheet to add all time spent of all copied rows using the Row ID

I would request you to please review this workflow and guide me if I can do it in better way? Thanks again.