Forum Discussion

CristinaMorales's avatar
CristinaMorales
Copper Contributor
Mar 31, 2023
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...
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Mar 31, 2023

    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's avatar
CristinaMorales
Copper Contributor
Mar 31, 2023
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"))
ganeshsanap's avatar
ganeshsanap
MVP
Mar 31, 2023

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

Resources