I have 2 sheets within my React app.
Sheet 2 needs to reference Sheet 1 but there seems to be a race condition as 50% of the time I get a ‘setState’ error which seems to be pointing to a #REF! error in Sheet 2s reference to Sheet 1.
I’m doing something like:
I think the issue is due to Sheet 1 being quite large (~300 rows) and hasn’t quite loaded in before Sheet 2 tries to render it.
Is there a solution for this kind of behaviour?