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")))
1. No it was not blank
2. They are 'Single line of text"
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!!!!