For lookup columns stuck with spinning icons, click the column header and select Force Rerun Column to reset and restart the process.
If that doesn't work, try clicking on the column header, hover over "Run column," and select Force to jump start the column run.
The infinite spinning could also indicate an infinite loop - check if your lookup setup creates circular references between tables or if the lookup triggers itself repeatedly. [1]
You can click into the specific cells showing "UNKNOWN" status to see more detailed error information.
If you still need help resolving the infinite spinning issue with your lookup, I’m here to assist. Would you like to provide more details about your lookup setup or any specific errors you’re encountering?