Forum Discussion
Solved
COUNTIF calculated column formula for Sharepoint Online
Hello, I have a formula that I got to work in excel, but am having trouble translating into a SharePoint Online calculated column formula. Am I able to use COUNT IF in a nested formula like this...
CristinaMorales Yes, workaround by creating another calculated column and using it will work. Or you have to make changes to existing formula which will become complicated. So, try using another calculated column.
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
Thanks ganeshsanap. What if I created another calculated column, set to number, to get a Count of "inaccurates", and then adjusted my formula so it looks at that Count column to see if the number is greater than two? Would something like the below work?
=IF(OR(ISBLANK([Q1?]),ISBLANK([Q2?]),ISBLANK([Q3?]),ISBLANK([Q4?]),ISBLANK([Q5?]),ISBLANK([Q6?]),ISBLANK([Q7?]),ISBLANK([Q8?]),ISBLANK([Q9]),ISBLANK([Q10?]),ISBLANK([Q11?])),"",IF(OR([Q1?]="Inaccurate",[Q2?]="Inaccurate",[Q4?]="Inaccurate",[Q5]="Inaccurate",[Q10?]="Inaccurate"),"Fail",IF[FailPassPW-LR-Count]>2,"Fail","Pass"))
=IF(OR(ISBLANK([Q1?]),ISBLANK([Q2?]),ISBLANK([Q3?]),ISBLANK([Q4?]),ISBLANK([Q5?]),ISBLANK([Q6?]),ISBLANK([Q7?]),ISBLANK([Q8?]),ISBLANK([Q9]),ISBLANK([Q10?]),ISBLANK([Q11?])),"",IF(OR([Q1?]="Inaccurate",[Q2?]="Inaccurate",[Q4?]="Inaccurate",[Q5]="Inaccurate",[Q10?]="Inaccurate"),"Fail",IF[FailPassPW-LR-Count]>2,"Fail","Pass"))
CristinaMorales Yes, workaround by creating another calculated column and using it will work. Or you have to make changes to existing formula which will become complicated. So, try using another calculated column.
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs