Forum Discussion
Solved
IF Formula question
Hello, I current have a formula I am using in SharePoint list that work great (see below), but I need to add in additional if statements which are creating failures. Working formula: =IF(ISB...
SLBMetrology In case of single line of text, use below formula:
=IF(ISBLANK([Date Completed]), "", IF(OR([5S Rating] = "0", [Documentation Rating] = "0"), "Fail", IF([Audit Rating] > 79, "Pass", "Fail")))
SLBMetrology Use below formula, it should work for you:
=IF(ISBLANK([Date Completed]), "", IF(OR([5S Rating] = 0, [Documentation Rating] = 0), "Fail", IF([Audit Rating] > 79, "Pass", "Fail")))Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Thank you for your help.
The formula you suggested did not fail, but it didn't give me the result I was looking for. When I tested it and added the 0 in for the Documentation Rating with the Audit Rating scare of 80 it did not change the status to Fail. Any thoughts??
- Was the [Date Completed] blank/empty for this record/item?
- What is the data type of [5S Rating]=0 and [Documentation Rating] columns?
- 1. No it was not blank
2. They are 'Single line of text"
