auto populate a date field

Bob Kernan

I would like to auto populate a "due date" field based off another date field on my sheet. I have an event date that reads from a request form and I want to have a task due date auto fill based off the event date.

Thanks!

Bob

Paul Newcome

Try

=[Date of Session]@row - 7

Bob Kernan

Perfect! Thanks Paul.

Andrée Starå

Hi @Bob Kernan

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bob Kernan

OK, the screen shot below has the two columns I need to work with. The "Date of Session" field is going to auto-populate from a form that gets filled out. That part I am good with. What I want to happen is When the "Date of Session" populates, the "Deck Due Date" will autofill with a date that is 7 days prior to the "Date of Session".

Paul Newcome

Try

=[Date of Session]@row - 7

Bob Kernan

Perfect! Thanks Paul.