title: How to create a "Loading" pop up in google sheets?
body: <p>I'm using the 'importrange' function in a 2 way setup between 2 sheets to hide proprietary formulas which takes a few seconds to update results to the current sheet.  What I would like to do is have a "Please wait while loading..." box pop up for X amount of seconds when user information in input cell.  I've seen some examples for pop ups but not sure how to do it when a cell is updated.... Any ideas?</p>