The "Error evaluating formula" issue you're experiencing with the "Lookup Single Row in Other Table" function can often be resolved by refreshing your browser. Try using the keyboard shortcut Cmd/Ctrl + Shift + R to perform a hard refresh. This should clear your browser cache and reload the page, potentially fixing the formula evaluation error.
If the issue persists after refreshing, let me know, and we can explore other troubleshooting steps.
Sean - Sorry for this, it looks like we've got a bug on our hands. I've escalated this to our engineering team to help look into it. We'll follow up here as soon as we know more!
Good news! Happy to report that we heard back from the team and this issue should be fixed.
Try a quick refresh (Cmd/Ctrl + Shift + R) and let us know if the problem has been resolved on your end, or if you still have trouble.
Thank you for your patience as we worked on it.