When added to a project, automatically add project to team member project page


I am a newbie with this, so hopefully I make sense.

What we are trying to do is when we add someone to a project, that they will have the project added automatically to their personal project page where they can keep track of their hours spent on the project.

Ideally we would like to see the total hours for each project get fed back to the sheet that keeps track of all the projects.

I have included 2 screen shots of the basic layout.

I was able to add the person to their sheet, but I had to use a helper column, which was hidden, it was very clumsy and did not work well.

Any help would be appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!