3 Replies Latest reply on Dec 6, 2018 7:19 AM by Lawand Bahram

    Calculated field where string

    Lawand Bahram

      Hi, I'd like to create a calculated field which is conditional on other rows. What I'd like to do is kind of this: IF (Account="abc") THEN grabvaluefromrowswith"def" ELSE whatIalreadyhave END.

       

      Is it possible somehow to grab the value where Account="def"?

       

      AccountValue
      Calc
      abc123
      def456
      ghi789