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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!