Does IMPORTRANGE automatically update the destination if the source is changed?

Question

Not sure if this has been answered else ware but, I'm trying to use the importrange function in Sheets to import a list of dates from spreadsheet A to spreadsheet B. That part works fine, however, if a date is changed in A, the importrange function won't auto-update B. Is there a way to get that auto-update to work?

I've looked at possibly using Google Script--I was hoping there was a way to run the importrange function using some sort of button (I don't mind clicking a button to update all importrange functions in B).

Answer 1

with IMPORTRANGE you can experience ~1 second delay:

• here I give you Spreadsheet A: https://docs.google.com/spreadsheets/d/

• and here is Spreadsheet B: https://docs.google.com/spreadsheets/d/

• IMPORTRANGE formula is:

=IMPORTRANGE("1FHFuMQYYYsKgraElTAEIEyzQLLsFOXX1U9udWPtSNsI", "Sheet1!A:A")

• gif proof: https://i.sstatic.net/oo1Ed.gif (open in new tab)