I put the Current time in the flow as a way to work out when it was dumped so i can see which is a duplicate. All I can get so far is the dump of all my tasks over and over so they duplicate everytime the flow runs. This is the flow i have now which does not fully work as it fails when it comes to the Row ID im not sure how to set that field to get it to always look at all the rows and update all of them. I can create a macro to erase info from the spreadsheet every day or use Excel to hide information with a certain date stamp but that becomes difficult to manage and rather clunky. Here is an excel formula trick to generate timestamps. Once the item is time stamped, it is much more easier to analyze it. so everyday I get a fresh dump of what is on my planner board without it doubling up in the spreadsheet. Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). The catch is I also need it to Update or at least delete the old information. What I wish to do is have all my tasks from Planner populate an Excel spreadsheet which will everyday dump what my tasks are. I need to have all Planner tasks that are assigned to me available for my manager to quickly look at so they can see my current workload without having to dig through Planner itself. I am having trouble trying to find a way to make Excel more dynamic.
0 Comments
Leave a Reply. |