I wondering if there was a way to move data from on column to the next when information is inputed into another column.


For example if I create a column in front of wk 1 allocation% and input a %. I would like week 1% to move to Week 2, week2 to move to week 3 and week 3 to move to week 4. Week 4 can just go away or I can create another column for it to move to.




Yes, there is. With a thorough multiple IF structure, it should work. Do you know how to set it up?

Have a fantastic week!


Andrée Starå

Workflow Consultant @ Get Done Consulting

In reply to by kari1282

Happy to help!

Unfortunately, I think I misread the question.

Do you add the values in the Wk 1 Allocation %, Wk 2, Wk 3 and so on manually?

If yes, it wouldn't work with the structure you have now because the manual input value would replace a formula. Would it work if we added another column where you could input the initial values?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])