Forum Discussion

Egemen's avatar
Egemen
Copper Contributor
Oct 07, 2022
Solved

Auto populate the multiple rows if the condition is met

Hi everyone,

I'm currently working on a recruitment forecasting file.

The idea is when someone enters 1 to any cell, excel should populate the possible timeline for the recruitment plan.

 

Example:

If July 2023 is the possible start date

April, May, and June 2023 are the training period

March is the notice period

February is interviews

The job ad posting is in January

 

How can I achieve this?

 

Please see the excel file and thank you so much for the support!

 

excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Oct 07, 2022

    Hi Egemen 

     

     

    Dates (and not Text values like Dec, Jan...) must be enterred in row 10. You can Custom format them to only display short month names if you want

     

    All Cond. Format. rules, but for Commencement, done with EDATE & XLOOKUP functions - see attached file

Resources