Calculated field two fields has to be set

Hi,

What is the syntax for this in a calculated field?

equal($statusgeneral_c,"closed")
equal($status_c,"closed")

I have tryied this, with no success.

equal($statusgeneral_c,"closed")

and
equal($status_c,"closed")

Regards J

Parents
  • Hi  ,

    If I am understanding correctly, you want both equal conditions to be validated in a single field formula. If that is an accurate understanding, you need to wrap everything in an and() formula, so it would look like this:

    Fullscreen
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    and(
    equal(
    $statusgeneral_c,
    "closed"
    ),
    equal(
    $status_c,
    "closed"
    )
    )
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    Let me know if that helps!

    Chris

Reply
  • Hi  ,

    If I am understanding correctly, you want both equal conditions to be validated in a single field formula. If that is an accurate understanding, you need to wrap everything in an and() formula, so it would look like this:

    Fullscreen
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    and(
    equal(
    $statusgeneral_c,
    "closed"
    ),
    equal(
    $status_c,
    "closed"
    )
    )
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    Let me know if that helps!

    Chris

Children