# IF(OR( formulas

Hi there,

I reached an impasse with IF(OR( formula. I've 3 columns named as below :

STATUS INMETEN / STATUS MODEL / Step 1 - Gescande Club

In each column, I've several data filled in. I wrote the following fucntion :

IF(OR([STATUS INMETEN]@row = "Inmeten afgerond", [STATUS INMETEN]@row = "2 - Pointcloud", [STATUS INMETEN]@row = "3 - Pointcloud", [STATUS INMETEN]@row = "Losse Pointcloud", [STATUS INMETEN]@row = "Pointcloud Extern", [STATUS INMETEN]@row = "Pointcloud", [STATUS MODEL]@row = "Niet uibesteed", [STATUS MODEL]@row = <>""), "#1 - Gescande Club")

(All "..." is data filled in cells of column "STATUS INMETEN" or "STATUS MODEL"

But this formula doesn't work for a reason I don't understand. Can someone help me out?

Tags:

• ✭✭✭✭✭✭

Are you getting an error or an unexpected result?

• Hi Paul,

Thanks for taking time to react on my post. I indeed find out the mistake. I simply changed the part = <>"")( at the end of the formulas) by = "").

What it looks like now :

IF(OR([STATUS INMETEN]@row = "Inmeten afgerond", [STATUS INMETEN]@row = "2 - Pointcloud", [STATUS INMETEN]@row = "3 - Pointcloud", [STATUS INMETEN]@row = "Losse Pointcloud", [STATUS INMETEN]@row = "Pointcloud Extern", [STATUS INMETEN]@row = "Pointcloud", [STATUS MODEL]@row = "Niet uibesteed", [STATUS MODEL]@row =""), "#1 - Gescande Club")

And it's working just fine ! Thanks for your time.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!