IF(Contains)

Becky Wilson

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.

Becky Wilson

Got it figured out with help from other responses to this type of questions. Used IF(HAS) instead.

Becky Wilson

Got it figured out with help from other responses to this type of questions. Used IF(HAS) instead.

Marcela

Awesome to hear you found a response, @Becky Wilson!

Please feel free to post your solution as well.

Cheers!