If Then Statement

Christy Kooiman

Hey all. I'm trying to figure out this formula, but keep getting Incorrect Argument Set. I need it to pull the close date +180 if the Type column contains CDM. Thank you in advance for your help!

=IF(Type:Type, CONTAINS("CDM", @cell), [Close Date]@row + 180, "")

Paul Newcome

Try this:

=IF(CONTAINS("CDM", Type:Type), [Close Date]@row + 180, "")

Paul Newcome

Try this:

=IF(CONTAINS("CDM", Type:Type), [Close Date]@row + 180, "")