If Then Statement

Options

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, "")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!