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

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.)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives