Set your progress percentages into a spreadsheet against each task.
Make sure that the tasks on the Asta view are lined up with the spreadsheet - I do this by filtering the tasks with no restraints so only the tasks show.
It is essential that they DO line up.
Set up the chart progress column to show percent complete - save this as a view called progress entry.
Make sure your progess period is set to the correct data date.
Now copy / paste all the spreadsheet percent numbers into the progress column and reschedule - job done in 3 minutes max - even with 10,000 tasks.
Member for
11 years 1 monthCheers guys, very helpful!
Cheers guys, very helpful!
Member for
10 years 2 monthsHi MikeThank you for thatJust
Hi Mike
Thank you for that
Just tried it
You have to use "paste values" instead of "paste" option
Works a treat thanks!
Member for
19 years 10 monthsHi Yasine - welcome to
Hi Yasine - welcome to planning planet.
Yes my method is very quick
Set your progress percentages into a spreadsheet against each task.
Make sure that the tasks on the Asta view are lined up with the spreadsheet - I do this by filtering the tasks with no restraints so only the tasks show.
It is essential that they DO line up.
Set up the chart progress column to show percent complete - save this as a view called progress entry.
Make sure your progess period is set to the correct data date.
Now copy / paste all the spreadsheet percent numbers into the progress column and reschedule - job done in 3 minutes max - even with 10,000 tasks.
Give it a try.
Best regards
Mike Testro