Formula for multiple Criteria


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!