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
-
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 Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
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 Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Great! Thanks heaps!
Help Article Resources
Categories
Check out the Formula Handbook template!