TODAY() Seems to cause #BLOCKED message

Dale Heincelman

I have researched this issue and I have tried several solutions.

I have set automation to insert the current date into my project schedule sheet, then automation to lock rows and then automation to unlock rows. This did not clear the issue.

I have created a separate sheet with automation to insert the current date into the project schedule sheet an reference the cell in this sheet. This did not clear the issue

I have removed the TODAY() function totally from my sheet . This did not clear the issue.

In my sheet I have the following formulas in my project schedule sheet:

=COUNTIFS([Critical Path]$29:[Critical Path]$56, 1, Status$29:Status$56, "In Progress", [End Date]$29:[End Date]$56, <[current date]@row)

=COUNTIFS([Critical Path]$29:[Critical Path]$56, 1, Status$29:Status$56, "In Progress", [End Date]$29:[End Date]$56, >[current date]@row)

Used to determine if a critical path task is on schedule or not as a metric. I then created a widget on my dashboard to display these metric on a bar chart to show status of all of the critical path tasks.

Total Critical path tasks, Critical Path Completed, Critical Path In Progress, Critical Path late In Progress & Critical Path Not Started.

I continue to get a #BLOCKED error on the dashboard. There are no error on the sheet with a project schedule.

What else can I do to resolve this issue?

Dale Heincelman

I just discovered a clue. I was investigating project schedule sheets of my co-workers and I discovered that the formulas with TODAY() without any of the fixes above do update on the dashboard widget when the person maintaining and updating content on the project schedule sheet is admin on the project schedule sheet and dashboard, not the owner. In at least 2 of the project folders I am the admin of the folder and all sheets contained in it. I am not totally sure if this is related but very strange behavior.