Skip to main content

Hello!


I would like to create a formula that automatically adds 14 workdays to a given date if that date is associate with a certain type of project.


For example, there is a list of projects with corresponding start dates. I would like to have their due dates automatically calculated based on their start date and only if they are a certain type of project.


Can anyone help?

Your formula would look something like this:

IF({name of your project type multiple select field}="Project Type A",DATEADD({name of your project start date field},14,'days'),BLANK())

Reply


Terms & Conditions