Going to +1 this. @Christophe_HK’s suggestion won’t entirely work for me because the admin and public apps have different row owner settings, which is going to be a nightmare to remember to turn off/on for each individual instance. Hopeful for a workaround eventually 
EDIT: clearly caffeine wearing out. Fixed by BOOOOOM 💥 - Change Source Sheet. Sorry for the necro.