Create the Ultimate Excel Action List: Smart Due Dates, Progress Icons, and More!

[@johnborg5419]

Thanks John

[@Up4Excel]

Thanks John, and Happy New Year 🎊 👍 John

[@tterrabend]

Brilliant! I love the automation of this action list, and thank you for providing the free template! I learned the "F2" tip for working within a formula (the bane of my existence, LOL, and I had no idea there was a fix for that). And I learned how to conditional format a whole row. Thank you! Will you please explain the "Days Left" column? I had thought it would be taking the due date less today's date and giving the number of days left to until the due date, but it's just a manually typed number. What does "Days Left" mean, then? (Thanks in advance.)

[@Up4Excel]

Glad you learnt some useful stuff here 👍 The days left is the duration of the task. I was going to call it duration but then I realised it needed to reduce as the task was being done. With hindsight I think 2 columns would be better, one for the total duration and one that calculates the remaining duration from the percentage complete. It should be fairly straightforward to change if you prefer that. Hope that explains it 👍 John

[@philip6661]

Hi I think your videos are great I've watched almost all of them I was wondering though why you stopped the free Up4Excel Downloads Library which I am very interested in are you still updating it do you have a shortcut to where I can get it please and hope youhave enjoyed the festive holidays

[@Up4Excel]

Glad you like my videos Philip👍 I still give away free downloads with all my videos but stopped maintaining the library as it became a bit too much to work. I now sell Up4Excel Pro, which is all the video workbooks, advert free versions of all videos, and a searchable index etc. If you're interested I'm actually doing a bundle offer on it at present here: gw.up4excel.com/up4excelpro-discount