Formula Help
Hello,
I feel like I am close with the current formula I am using in a build out. Could use some help if anyone has suggestions.
I have a section where AutoFail is possible and then a Section that is Pass/Fail based on %'s.
If they Pass the Pass/Fail Portion but Auto Fail the other portion the entire total score is Auto Fail. If they Pass the Auto Fail portion but Fail the Pass/Fail area, then the return should be Fail.
I am currently using this formula:
=IF([Auto Fail Total]@row =0, "AUTO FAIL", IF([Pass/Fail %]@row >= 0.6, "PASS", IF([Pass/Fail %]@row < 0.6, "FAIL")))
The only part it is not returning when I run tests is the Fail if the score is below 60%.
Any help would be greatly appreciated.
Best Answer
-
For anyone else who may need it the formula that ended up working is listed below.
=IF([Auto Fail Total]@row = 0, "AUTO FAIL", IF(AND([Total Score 60%=Passing]@row >= 0.6), "PASS", "FAIL"))
Answers
-
Try saving & refreshing, I see no issues when using the formula you provided.
Larry Cummings
https://primeconsulting.com/
Principal Consultant | Prime Consulting Group -
Hey Larry,
I tried saving and refreshing and it is still showing pass when it should be showing fail with a total % score below 60% and they did not auto fail.
Thanks for saying you see no issue when using the formula I provided.
I am super confused on why the formula would not be working correctly especially with another set of eyes on it.
I may just leave it alone for a day and see if it starts to work properly. I know that might be a long shot but may be worth it.
If I hear or get other responses on formulas, I will try those as well to see what happens.
-
For anyone else who may need it the formula that ended up working is listed below.
=IF([Auto Fail Total]@row = 0, "AUTO FAIL", IF(AND([Total Score 60%=Passing]@row >= 0.6), "PASS", "FAIL"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!