Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Need Help with Automation/ Formula for updating a table whenever a condition is met

Topic Labels: Automations
Solved
Jump to Solution
392 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Thank you for helping in advance. I want to create a formula or an automation that automatically sets the “Business Due Date” 16 weeks after the “Onboarding Call Date” whenever a record is entered in “Onboarding Call Date”. I don’t know if there is a formula for this or an automation.

Any advice will be helpful.automation_1

1 Solution

Accepted Solutions

Hi @Muhammad_Faheem,

you can use a formula that will sum 16 weeks on the date in “Onboarding call date”.

The formula is here:

DATEADD(Onboarding call date,16,'week')

The date add puts 16 weeks in the date you mention in the first field of the function.

Please text us back if this worked for you and if you have any further question please do not hesitate to text us back.

Thanks,
Dimitris Goudis

See Solution in Thread

1 Reply 1

Hi @Muhammad_Faheem,

you can use a formula that will sum 16 weeks on the date in “Onboarding call date”.

The formula is here:

DATEADD(Onboarding call date,16,'week')

The date add puts 16 weeks in the date you mention in the first field of the function.

Please text us back if this worked for you and if you have any further question please do not hesitate to text us back.

Thanks,
Dimitris Goudis