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

[Muhammad_Faheem]

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.

[Dimitris_Goudis · Accepted solution]

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