How to solve #BLOCKED?
I recently notice in my spreadsheet that the formulas I've been using stop working after I deleted some rows with data I didn't need anymore.
The formulas are the following:
1st column =MAX(COLLECT([Service End Date]:[Service End Date], [Account Number]:[Account Number], [Account Number]@row))
2nd column =IF([Most Recent Bill Date]@row = [Service End Date]@row, true, false)
3rd column =IF([Most Recent Bill Date]@row < (TODAY() - 45), true, false)
Why is this happening? How can I fix it ? And how can I avoid this error from happening again?
NOTE: when I copy the formulas on a another spreadsheet they work fine.