Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hello,
We are working on an interdepartmental project where each department has created a project sheet listing and assigning all main tasks that team is responsible for. I would like people to then create individual task lists further breaking down all the things they need to do to complete the main task. is there a way to connect each task list to its corresponding row on the department project sheet?
TIA!
Maybe you could create an IF formula that includes the link to the assignee's task list?
=IF(assignee1="Jim Halpert", "http://www.smartsheetlinktopersonaltasklist.com", IF(assignee1="Dwight Schrute", "http:///www.smartshetlinktopersonaltasklist.com", IF(assignee1="Kevin Malone", "http://www.smartsheetlinktopersonaltasklist.com")))
Let me know if you have any issues.
You may want to consider listing all the tasks on the main project tab, so that you can assign predecessors accordingly. I understand this can make for a complex sheet, but the benefit of having everything in one place could be worth it. You can then expand and collapse the plan to the level of detail that a conversation requires. You could then create shared filters for each department or team member showing their open tasks, etc.
this is an interesting fix! would you suggest doing a column separate from the "Task Name" column to include the hyperlink?
For dynamic effect you could... but you could also just update the formula in the first row that contains it and drag it down from the bottom-right corner to adjust it for the others.
