What is wrong with my nested if? It says that that It’s invalid
IF(
AND(
{5dayswithnochange},
{issueStatus🟢or
or🟠}=🟢
),
"Stable 
",
IF(
AND(
{5dayswithnochange},
{issueStatus🟢oror🟠}=🟠
),
"Stuck 
",
IF(
AND(
{5dayswithnochange},
{issueStatus🟢oror🟠}=
),
"Broken 
",
"Too soon to tell 
"
)
)
)
nevermind, I forgot to add the quotes “” around the emojis :green_circle: in the equality evaluations
Correct code
IF(
AND(
{5dayswithnochange},
{issueStatus🟢oror🟠}="🟢"
),
"Stable ",
IF(
AND(
{5dayswithnochange},
{issueStatus🟢oror🟠}="🟠"
),
"Stuck ",
IF(
AND(
{5dayswithnochange},
{issueStatus🟢oror🟠}=""
),
"Broken ",
"Too soon to tell "
)
)
)
Glad you were able to fix your issue yourself!
However, I happened to see your formula and thought you might be interested in a slightly simpler version. This version has less nesting and eliminates the need for the AND functions. It also uses the SWITCH function, which is really useful for when dealing with multiple possible values for a single field.
IF ({5dayswithnochange},
SWITCH({issueStatus🟢oror🟠},
"🟢", "Stable ",
"🟠", "Stuck ",
"", "Broken "
),
"Too soon to tell "
)
Glad you were able to fix your issue yourself!
However, I happened to see your formula and thought you might be interested in a slightly simpler version. This version has less nesting and eliminates the need for the AND functions. It also uses the SWITCH function, which is really useful for when dealing with multiple possible values for a single field.
IF ({5dayswithnochange},
SWITCH({issueStatus🟢oror🟠},
"🟢", "Stable ",
"🟠", "Stuck ",
"", "Broken "
),
"Too soon to tell "
)
Tank you! simpler syntax indeed.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.