Forum Discussion

SamWhite's avatar
SamWhite
Frequent Visitor
2 years ago

Custom Column String comparison not working

I have excel file which has a column called Result, it has either values of "Approved" or null. I am writing a if function in custom column which is checking few conditions like: if [Required]=true ...
Need Help
dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
2 years ago

Hi, are you sure that you have boolean values true or false in [Required] column? In my opition you have text values "true" or "false" there. If I'm correct, this should help you:

 

if [Required]="true" then "Yes"
else if [Result]="Approved" then "Completed"
else "Not Completed"

 

SamWhite's avatar
SamWhite
Frequent Visitor
2 years ago

The error is not on the boolean value. The error is for the below line:

else if [Result]="Approved" then "Completed"

 Where-ever Result is equal to Approved is not resulting in Completed. It gives ERROR is the custom coulmn. 

  • dufoq3's avatar
    dufoq3
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Provide at least screenshot od your data - mentioned columns and screenshot of error please.