Solved: Re: Column Formula help

Anonymous · ‎07-11-2022

Dear Experts

Can someone please help me with the column formula to have Yes or No based on the Column A.

Column B to have yes if any text is available in the Column A.

Thanks in advance
Mahad

ryan_mayu · ‎07-11-2022

@Anonymous

pls try this

ColumnB = if('Table'[columnA]="","No","Yes")

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

ryan_mayu · ‎07-11-2022

@Anonymous

pls try this

ColumnB = if('Table'[columnA]="","No","Yes")

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

tamerj1 · ‎07-11-2022

Hi @Anonymous

please use

IF ( ISBLANK ( TableName[Column A] ), "No", "Yes" )

Column Formula help