Using OR in a formula

aecross
aecross ✭✭✭
edited 03/13/23 in Formulas and Functions

Hi there -

My goal is to have a formula that notes if Bayside Conversion is Completed or Completed - Not Implemented, then enter 5 into cell, otherwise enter 0.

Here is my current formula, I am getting "UNPARSEABLE"

=IF([BAYSIDE CONVERSION]@row = "COMPLETED", OR(@row = "COMPLETED - NOT IMPLEMENTED", 5, 0))


Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!