Automation Reminder Message
I set up reminder messaged to send to the "Assigned to" Individual one week before the "Send Internal Project Pre-Planning Meeting Invite" task target date. The sheet name is generic (Project Plan) -- I'd like the message to include a reference to the Project Name... The Project Name, however, is a linked cell within the Task Name so I'm not sure how to reference that specific cell.
Is there a way to do this?
Answers
-
Hi @EJ ,
You could create a helper column that uses the Ancestors() formula to pull that information into a row, which would allow you to include it in the alert.
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives