Auto Populate Dates

Jermaine Johnson

Hi Everyone,

I am trying to auto-populate dates based on a certain column, which would update/change/auto-pupulate future dates in other columns within my sheet

Example

IF I put in a date 01/03/2022 in BCA completion date

I would like RR Completion date to auto populate a due date of 01/05/2022 (due within 2 days

I would like the IT Solution date to auto populate a due date of 01/10/2022) due within 7 days from the BCA date)

Andrée Starå

@Jermaine Johnson

Happy to help!

Try something like this.

RR Completion Date

=[BCA Completion Date]@row + 2

IT Solution Date

=[BCA Completion Date]@row + 7

Did that work/help?

✅Remember! 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!

Andrée Starå

@Jermaine Johnson

Excellent!

You're more than welcome!

✅Remember! 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!

Andrée Starå

Hi @Jermaine Johnson

I hope you're well and safe!

Not sure I follow.

What is the issue?

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!

Jermaine Johnson

@Andrée Starå Thanks for connecting. I am looking for the formula to help auto-populate dates in additional columns.

Example

IF I input the date 01/03/2022 in BCA completion date.

I would like RR Completion date to auto populate a due date within the next 2 days (1/5/2022)

I would like the IT Solution date to auto populate a due date of 01/10/2022 due within 7 days from the BCA date.

Not sure the formula (=if or =date)

Does this help?

Andrée Starå

@Jermaine Johnson

Happy to help!

Try something like this.

RR Completion Date

=[BCA Completion Date]@row + 2

IT Solution Date

=[BCA Completion Date]@row + 7

Did that work/help?

✅Remember! 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!

Jermaine Johnson

@Andrée Starå Worked perfect! Thank you again for all your help & support

Cheers,

Jay

Andrée Starå

@Jermaine Johnson

Excellent!

You're more than welcome!

✅Remember! 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!

ccs

I was trying to do something similar, I would have a start date that I manually inputted and then I would put an estimation in months and needed it to generate what the end date would be. I used the AI formula generation tool and it gave me this which works!

It is kind of ugly when there is no date in the column but it gets the job done.

=DATE(YEAR([StartDate]@row) + INT((MONTH([Start Date]@row) + VALUE([Estimated Effort inMonths]@row) - 1) / 12), MOD(MONTH([Start Date]@row) + VALUE([Estimated Effortin Months]@row) - 1, 12) + 1, DAY([Start Date]@row))