"Significant" is subjective here, but it needs to be a large enough effect that something like opening a window or otherwise increasing air flow could have a notable impact on one's productivity.

I'm talking about "normal" concentrations. Obviously if you put someone in an atmosphere of 100% CO2, that will have a negative effect.

Resolves once there's a well-established scientific consensus.