I am developing a KPi, where am using a column named Complete which contains Yes/No field in it. For this if i write a calculated value for yes/no field:


its not working. What should be the correct calcualted value for this field. IF Yes it should display 1 and no means 0. It should set the value using this calculation. thanks in advance!!

2 Answers 2


The correct formula should be like that:

=IF([CompletedTask], "Yes", "No")

Please try it like this:

=IF([CompletedTask]=1, "Yes", "No")

below is the reference for other formulas:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.