Parent with Left & Find
I'm trying to create a column formula that will populate with the leftmost word in the Parent column.
I know this formula works:
=LEFT([Task Name]@row, FIND(" ", [Task Name]@row) - 1)
But when I put PARENT in front, it comes back as #UNPARSEABLE
=PARENT(LEFT([Task Name]@row, FIND(" ", [Task Name]@row) - 1))
What am I doing wrong? Is this not possible? Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!