IF(Contains)

I am using the IF(Contains formula to look at values in the Numbers to Include column, which is a multi-select drop down column, and it if finds the value to add a number to the Office Phone column.

=IF(CONTAINS("Main Office: 303-932-0757", [Numbers to Include]@row, "303-932-0757", ""))

This formula is in the Office Phone cell for the current row.

I am getting an Incorrect arguments error.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!