How can I create a "button" on a Google Sheet that "allows" IMPORTANTRANGE() to function?

Question

I have used Google Sheets for awhile, but am now finally getting into using more advanced functions, such as "IMPORTRANGE()". I currently have a work schedule in a Sheet that my employees can access to see what time they're scheduled to work that day. I used IMPORTRANGE to pull that data from my source file to the sheet that everyone views (so I can work on the sheet without having to hide tabs from everyone, I often forget). What I'm trying to do is find a way that I can "toggle" whether or not the "IMPORTRANGE()" function will work on a particular range. Almost like a "schedule post" button, where unless I "click" the button, or "check" the checkbox, in the source file, it won't allow the data to import from my source file. Hopefully that makes sense. Looking for some guidance if anyone can shed some light.
Thank you!

{Stephen,G} · Accepted Answer

Hello Nick P. 3537,
 
I think something like this would work. You have a checkbox in your sheet we'll use cell D2 just for this example. When you check that box the IMPORTRANGE() will show in the other sheet. It would look something like this.
 
=IF(IMPORTRANGE("url","yoursheet!D2")=True,IMPORTRANGE("url","yoursheet!data_range"),)
 
If that doesn't work or you still need more help with this I suggest that you share an editable COPY of your sheet. Use your sample sheet to demonstrate what you'd like the sheet to do!  Here are some tips to help you get a great answer quickly... Product Experts TIPS FOR SHARING  
 
Stephen