# Calculated column to calculate approved status workflow

How to use calculated column to calculate approved status workflow?

I tried this but it doesn't work.

``````IF([Approve status]="Pendding", 1, 0)
``````
• What are you trying to achieve here exactly using calculated column? Commented Aug 18, 2022 at 7:24
• You cannot count multiple items based on status using calculated column. calculated column can only reference the column values from single item/row. easiest way is to use grouping, check my updated answer below for more information. Commented Aug 18, 2022 at 7:58
• Ik I want to create 3 columns, each column will count a status , then will sum all the 1s Commented Aug 18, 2022 at 8:07
• In that case, you can create 3 columns for 3 different status values & use formulas like: `=IF([Approval Status]="Pending",1,0)` for Pending calculated column and `=IF([Approval Status]="Approved",1,0)` for Approved calculated column. Refer to the formula & column settings given in my answer. Commented Aug 18, 2022 at 8:21
• =IF([Approval Status]="Pending",1,0) doesn't work Commented Aug 18, 2022 at 9:49

Looks like you want the calculated column to return a Yes/No value; try this:

``````IF([Approve status]="Pendding", true, false)
``````

If you are trying to create a calculated column based on approval status column, use formula like:

``````=IF([Approval Status]="Pending",1,0)
``````

This will return `1` value in calculated column when Approval Status is equal to "Pending" else it will return `0` as value of calculated column.

Calculated column settings:

Follow steps given in my answer to create a calculated column in a list at: Formula does not work for SharePoint/Lists

Note:

1. Sometimes comma(`,`) does not work in formula (I am not sure but it is based on language or regional settings on your site). In that case use semicolon(`;`) instead of comma(`,`) at all places in above formula.
2. You cannot use "calculated value" option of existing columns as this option cannot reference other columns in list in formula. So, you have to create a column with "calculated" data type for referencing other columns in list in calculated formula.
3. You have to use the correct "display" name of Approval Status column in your formula.