Multiple conditions with IF and PARENT ()

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?

Best Answer


  • Great! Thanks heaps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!