If your Lookup Single Row function is stuck on running for over an hour, there are a few steps you can try to resolve this issue:
1. Double-click on the row to see if it shows "waiting for its inputs." If so, click "re-run this cell" to make it work.
2. Toggle the auto-update off and on again:
• Click the Auto-update icon at the bottom right of your table
• Select "Turn off Table"
• Then turn it back on and accept the run prompt
3. If the issue persists, try forcing a run:
• Right-click on the column
• Hover over "Run Column" > "Force Run All Rows"
If these steps don't resolve the issue, you may need to request human assistance for further troubleshooting.