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!!


The correct formula should be like that:

=IF([CompletedTask], "Yes", "No")
|improve this answer|||||

Please try it like this:

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

below is the reference for other formulas:


|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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