Skip to main content

Conditional Statement Using Multiple Select

  • January 14, 2019
  • 1 reply
  • 15 views
L

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

    Kamille_Parks11
    Forum|alt.badge.img+27

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

    B
    L
    Terms & ConditionsAccessibility statement