Help Please....Formula to Copy Cell to Another Cell Based on %Complete and Assigned Resource
I would like an automated way to copy the task descriptions that are assigned to specific resources (person), that are less than 100% completed into a different column.
- I created a new column called Kerry's Tasks
- Now, if my Assigned Resource Column contains Kerry, AND
- My %Complete Column is less than 100%
- COPY the contents in my Task Description Column into the Kerry's Tasks Column AND
- If the %Complete Column is =100% delete or clear the cell in the Kerry's Task Column
I'm trying to get all tasks assigned to individual resources into their respective column and automate the updates to keep it current with %Complete.
Many Thanks - Kerry
Help Article Resources
Check out the Formula Handbook template!