Help

Conditional Statement Using Multiple Select

1349 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Logan_Willans
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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