Multiple conditions with IF and PARENT ()

Jean Kim

Trying to get multiple conditions working with IF + PARENT ()

If formula works when it's used alone.

 =IF(Type@row = "task", "") -> Works

=IF(Type@row = "subtask", PARENT(ID@row)) -> Works

However, when I tried to combine the formula, it returns UNPARSEARBLE.

 =IF(Type@row = "task", ""), if(type@row="subtask", PARENT(ID@row)) -> Doesn't work.

What is wrong with above formula?

Ramzi K

In your formula:

=IF(Type@row = "task", ""), if(type@row="subtask", PARENT(ID@row))

You are missing you closed the firs if too soon (with the ")" coming too early. You also need the "if false" clause at the end.

Try this:

=IF(Type@row = "task", "", if(Type@row="subtask", PARENT(ID@row),"")

Cheers,

Ramzi

Ramzi K

In your formula:

=IF(Type@row = "task", ""), if(type@row="subtask", PARENT(ID@row))

You are missing you closed the firs if too soon (with the ")" coming too early. You also need the "if false" clause at the end.

Try this:

=IF(Type@row = "task", "", if(Type@row="subtask", PARENT(ID@row),"")

Cheers,

Ramzi

Jean Kim

Great! Thanks heaps!