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