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!