Forum Discussion
COUNTIF calculated column formula for Sharepoint Online
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
CristinaMorales COUNTIF is not supported in SharePoint calculated formulas.
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"))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
