Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Need help with getting parent and sub parent data
I have a format that looks like this
I am looking for a formula that adds text to a column for each name structured as "Project Name - PreCon" or "Project Name - Construction"
I can get it to work using explicit references
=PARENT([Task Name]13) + " " + PARENT([Task Name]14)
This only works for the first Name row and then I need to edit each subsequent Name row. Can this formula be edited to always pull in the "Project Name" and "PreCon/Con" info?