Formula for multiple Criteria

Options
✭✭

Hello,

I need a formula to put a word “READY” to ColumnA Row if ColumnB value contains a word “Invoice” OR if ColumnC value start with number 1 or 2 or 3.

ColumnA        ColumnB              ColumnC

READY           Invoice 1

READY                                          13437

READY           invoice 24

READY                                           2399

Thank you for you help.

Best Answer

• ✭✭✭✭✭✭
Answer ✓
Options

Hi @BonW,

Try this.

=IF(OR(CONTAINS("Invoice", ColumnB@row), LEFT(ColumnC@row, 1) = 1, LEFT(ColumnC@row, 1) = 2, LEFT(ColumnC@row, 1) = 3), "Ready")

Hope that helps,

Dave

Answers

• ✭✭✭✭✭✭
Answer ✓
Options

Hi @BonW,

Try this.

=IF(OR(CONTAINS("Invoice", ColumnB@row), LEFT(ColumnC@row, 1) = 1, LEFT(ColumnC@row, 1) = 2, LEFT(ColumnC@row, 1) = 3), "Ready")

Hope that helps,

Dave

• ✭✭
Options

IT WORK! Thank you very much Dave for your help. I'm still learning.😀

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!