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")))
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"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")))- Worked perfectly!! I cannot thank you enough. I knew this would be easy for the right person. Much appreciated!! Have an amazing day!!!!