I have a calculated column that gives an 'estimated completion date' for tasks in the list.

My issue is that the calculation for the est completion date doesn't update unless I edit the column and save it. I don't want to do that every day.

Is there a way to get the calculated column (estimated days left + now()) to update on a daily basis?

Hi

yes,

create and schedule a powershell script which will fill that column at midnight with needed values

I don't believe I have access to do that. I am on a collaboration environment and don't have access to the server itself.

If you have access to workflows you can just run an update workflow at midnight to do what you want. Seeing as you don't have access to the server for PowerShell

I've been looking in to that and haven't been able to find out anything about an update workflow that I can run nightly. Can you please help with how that would be done?