IF OR help, please

jb@59069 ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have a column (Project ID), with multiple values and a column (Bill Rate) that needs to be populated based on the value in Project ID.

I need to screen Project ID for two (2) specific entries, "NRM Logistics" and NRM-0418 Logistics" and have Bill Rate populated with "Rate5" if either of these are found or Rate2 for everything else.

This formula is not working. Where am I off track?

=IF(OR([Project ID]89 = "NRM Logistics", [Project ID]89 = "NRM-0418 Logistics", "Rate5", "Rate2"))




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!