The production of charm quarks and charmonium states in fixed-target collisions provides a powerful probe of QCD in cold and hot nuclear matter. The LHCb experiment has pioneered a novel fixed-target program, now enhanced for Run 3 with the SMOG2 system, which features improved gas confinement and the capability to inject both noble and non-noble gases. This upgrade significantly increases fixed-target luminosity, enabling high-statistics studies of charm production in proton-nucleus ($p$A) and lead-nucleus (PbA) collisions. Charm production measurements in this environment offer unique insights into cold nuclear matter effects, such as nuclear PDF modifications, parton energy loss, and intrinsic charm contributions, across small and large collision systems at the same center-of-mass energy per nucleon pair ($\sqrt{s_{NN}}$). Additionally, these measurements provide an opportunity to investigate potential signatures of hot nuclear matter effects at lower energies. Results on open and hidden charm production using the $p$Ne and PbNe datasets collected with SMOG are presented, as well as future prospects for charm studies in fixed-target collisions with SMOG2.