Automated Message Workflow Changes Cell to #BLOCKED
I have a sheet that calculates a score based on responses from a form. In that form, the user can submit their email that is then added to a contact list column. I have also set up an automated workflow that shares the score from their submission to the email submitted on the form through a message. When the submission populates, the score calculates correctly, but will switch to #BLOCKED without refreshing the page (I can watch this happen), thus sending the score as #BLOCKED in the sent message. When I refresh the sheet, the score will calculate correctly and the workflow will resend the message to the user with the score showing. What is causing this error?
Edit: I resolved the error by referencing the calculated value in an additional column next to the calculated score. I think maybe the formula was causing a bug?