Conditional Statement Using Multiple Select


#1

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?


#2

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())