i'm having trouble using the generate arbitary attribute

nohanoha Member Posts: 10 Learner I
edited June 2020 in Help
i want to write an expression that means. If the text column contains keywords 1, 2 and 3 it classifies them as important else it classifies them to be not important. i tried this but it's not working
if([Text](contains(%{keyword1} || %{keyword2} || %{keyword3})), "important", "not important")

Answers

  • nohanoha Member Posts: 10 Learner I
    i also tried this if([Text]==eval(#{keyword1}||#{keyword2}||#{keyword3}), "not important", "important")
Sign In or Register to comment.