Structure : How to make the cell empty when if all not

[yirang Im]

Hi!

I am writing a formula languge in structure.

The formula is like following

IF(issuetype=task & Condition A, "A", 

    issuetype=task & Condition B, "B",

    issuetype=task & Condition C, "C",

    issuetype=task  & Condition D, "D",

    issuetype=subtask & Condition A, "A", 

    issuetype=subtask & Condition B, "B",

    issuetype=subtask & Condition C, "C",

    issuetype=subtask  & Condition D, "D", "")

For 'subtask', I can see the empty cell where if a condition is missing. 

But random expression shows up in the case of 'task'. I want to make it empty too if the condition is not matched.

What should I put more in this formula? Need an advice from experts.

Thank you in advance!

[Ditte Simard · Accepted solution]

Hi @yirang Im !

I am not able to recreate your error, but maybe you should try breaking up your IF statement into two IF statements like this:

/*check if task issuetype*/
IF issuetype="task":
IF (condition A, "A",
condition B, "B",
condition C, "C",
condition D, "D", " ")

/*check if sub-task issuetype*/
IF issuetype="subtask":
IF (condition A, "A",
condition B, "B",
condition C, "C",
condition D, "D", " ")

This might help you find where the error is occurring.

[yirang Im]

@Ditte Simard This helps me a lot. Thank you :)