automatically move date from one column to the next

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.

Find more posts tagged with

Formulas

Legal

Project Management

Comments

Andrée Starå

Hi,

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

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Karrie Davis

I do not will you be able to help me.

Thank you

Andrée Starå

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, andree@getdone.se)

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Index/Match - Primary Sheet to Individual Sheet
Hi Community, I am looking to track training at the individual employee level as well as for my company overall to provide statistics. Currently I have two sheets. One is the primary tracker, and the second is an individual employee sheet (template). The primary tracker has approximately 107 columns, each column represents…
How do I limit the number of entries under the same company name
I have a list of companies that are allowed 2 complimentary registrations. I want a notification sent if a third registration is added that tell the company rep they need to pay for the third registration. I have a list of company names with the contact information. I then have the registration list with a form for…
Iferror using multiple sheets
Hello, I have a sheet titled "4G Cradlepoints" with the serial number in the first column, Column name is "Serial Number". Each serial number is listed once. I have another sheet named "All Sites" and the 60th Column is named "4G Cradlepoint SN". The serial number will be listed multiple times in the "All Sites" sheet…