Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Formula for nested ifs condition

Hi,

 

Would like to seek your help on the below. 

 

if Priority = 2 hours, then Pass, if not 2 hours, then failed, 

if Priority = 4 hours, then Pass, if not 4 hours, then failed

 

 

Thank you so much for your answers. God Bless You

 

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PabloDeheza's avatar
    PabloDeheza
    3 years ago

    Try this:

    IF (
    priority = "p1",
    IF (
        duration <= 2,
        "Pass",
        "Fail"
    ),
    IF (
        priority = "p2",
        IF (
            duration <= 4,
            "Pass",
            "Fail"
        ),
        BLANK ()
    )
)

5 Replies

  • PabloDeheza's avatar
    PabloDeheza
    Solution Sage
    3 years ago

    Hi there!

    Try something like this:

    SWITCH(
	SELECTEDVALUE( Priority ),
	"2 hours", "Pass",
	"4 hours", "Pass",
	"failed"
)

    If your priority column is numeric then dont use double quotes.

    Let me know if that helps!

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      hi, in bo the formula should be:

       

      if (priority = p1, then (if duration <= 2,  "pass", "fail") elseif (priority=p2, then (if duration >=4, "pass", "fail")

      else "null"

      • PabloDeheza's avatar
        PabloDeheza
        Solution Sage
        3 years ago

        Try this:

        IF (
    priority = "p1",
    IF (
        duration <= 2,
        "Pass",
        "Fail"
    ),
    IF (
        priority = "p2",
        IF (
            duration <= 4,
            "Pass",
            "Fail"
        ),
        BLANK ()
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    that worked. thank you very much. 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    how about if priority and duration are on a different table?