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.

Display predecessor task NAME

Robin Rice
Robin Rice โœญโœญ
edited 12/09/19 in Archived 2017 Posts

We would like to write logic to display all predecessor task NAMES in a new column. ย So we want the predecessor task ID to be in its usual column, and we want a NEW column that shows the NAMES of the predecessor tasks.

ย 

Anyone done anything like that?

ย 

Thanks

Robin

ย 

Comments

  • Hi Robin,

    There isn't a way to create this functionality with a formula or existing Smartsheet functionality, mostly due to Smartsheet not having a way for you to dynamically reference row numbers in a formula.ย 

    If you have development resources, you might consider utilizing our API to facilitate this. Our API documentation can be found here:ย https://smartsheet-platform.github.io/api-docs/

    You're also welcome to submit your idea to our Product team using the Product Enhancement Request form in the Quick links sectionโ€”let them know how you'd like to see this work in Smartsheet (a special column type, using a formula, etc.)

This discussion has been closed.