Calculated Colum based on checkbox Yes/No value

Question

Calculated Colum based on checkbox Yes/No value

carola baars 1

For a text value column yes/no the following formula works =IF([Colum1]="yes";Colum2). I would prefer to have the Yes/No checkbox column do the same thing, however I am sofar unable to get that working/done.

Tried: =IF(Colum1]=TRUE;Colum2)
and =IF([colum1]=1;"Yes";"No")
and =IF([Gekozen stromen]=TRUE;"Yes";"no")

Love to hear your input

CaseyYang-MSFT 10,456 Reputation points

2022-04-18T02:01:27.653+00:00

Hi @carola baars ,

Thank you for your question. We will give you an update as soon as possible.

1 answer

Your answer

CaseyYang-MSFT 10,456 Reputation points

2022-04-18T02:01:27.653+00:00

Hi @carola baars ,

Thank you for your question. We will give you an update as soon as possible.

Answer 1

CaseyYang-MSFT 10,456

Hi @carola baars ,

Per my test, you could use following formula:

=IF([Yes/No]=TRUE,"Yes","No")

My test result:

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

CaseyYang-MSFT 10,456 Reputation points

2022-04-21T06:37:23.17+00:00

Hi @carola baars ,

Would my answer be helpful to you? Is there any update on this thread? Comment here if you still need any help.
carola baars 1 Reputation point

2022-04-21T17:07:21.757+00:00

thanks for your input Casey.
CaseyYang-MSFT 10,456 Reputation points

2022-04-22T01:34:02.237+00:00

Hi @carola baars ,

If this answer helpful to you, please remember to accept them. It will help others who meet the similar question in this forum. Thank you for your understanding.

Share via

Calculated Colum based on checkbox Yes/No value

1 answer

Your answer