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

Options

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

Answers

  • DataLime
    Options

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

  • DataLime
    Options

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

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • DataLime
    Options

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!