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?
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!