If/then formula issue
We are using a form to perform inspections. If any inspection enters contain a "no" to any question it automatically becomes a "fail" for that inspection.
I am trying to build a formula that will calculate a "Fail" if any of the entries in the row are "No". I have tried everything I can find and I am struggling to find a solution.
Here is one of the many I have tried. =IF(CONTAINS("No", [1.1 Product Schedule - Uploaded on EIDA?]@row, [1.3 Drawings]@row, [1.4 Product Data]@row, [2.1 Applicator]@row), "Fail")
TIA for any help.
Jacque Smith
Project Controls, MSR-FSR
Answers
-
Hi @jacquedale,
Try something like this.
=IF(OR([1.1 Product Schedule - Uploaded on EIDA?]@row = "No",[1.3 Drawings]@row = "No",[1.4 Product Data]@row, [2.1 Applicator]@row ="No"),"Fail")
Hope this helps,
Dave
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!