Find next Item number and Product in set of data

Iron Contributor

Hi,

 

I have a project which will contain a list of tasks to be completed, which will be constantly being updated. I will to have a summary that will track the item and product for each, and have as a table to mark as completed as we progress. 

 

I am hoping to have a formula to find the next task item, and then populate the one copy of each for each product.

 

Attached is an example, which i am to do the following:

1. As as task is added to the last list on the "list of tasks tab", I want a row to populate for each fund so I can then track and monitor as each is completed.

2. I then wish to show the fund name for each task row, so that the owner of each can find and update.

 

Can someone please assist.

 

Kind regards,

0 Replies