Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditional column didn't works

Dear expert   I try to set up Conditional column but it didn't shows on all the column. Most of the column shows "Error" and didn't works for some reason. I did set up exactly same condition on ano...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

either your discounts or style price columns are empty ("null") - You need to convert the nulls to some value, or use the advanced editor to change your conditional rules to account for nulls.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the reply. 

I figure out the reason why it didn't works. The spreedsheet i am working on was combined two excel spreedsheet and only one of the spreedsheet the condition column is working and the other half of the spreedsheet the column didn't works.

 

Do you know how to solve this issue?

 

Please advise, thank you

 

Maggie

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    Hello Anonymous 

     

    without any additional information it's impossible to say why your combined dataset is not working.

    Maybe before you are combining them you select only specific columns and then this data is missing for your conditional formula. Maybe in some sheet its text on another is a number. Can you share your query and post some screenshots?

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy