Forum Discussion
PierrickE
Sep 15, 2022Copper Contributor
How could I automate a tracking list of "how many projects users were on at given dates"
Hi, I managed to get where I needed to, certainly not in the most efficient way, but it's working. Now, I would like to automate the process if the data sheet is updated. So, from a data she...
MichelleRanMSFT
Microsoft
Oct 05, 2022Hi PierrickE,
Thanks for reaching out and apologies for the delayed response! I think an Office Script might be able to help you out; to double-check, do you have access to the Office Scripts feature? You can confirm this by seeing if you have the Automate tab in Excel on the web.
If you can use Office Scripts - before I give specific suggestions, could you clarify what you mean when you mentioned that dates are going to move?
Best,
Michelle