1) Why isn't my 'importrange' working on Google sheet? The sheet does not update itself automatically. Sometimes it works, sometimes it doesn't. What are the possibilities of fault?
2) Is it possible for the importrange content to change when it is being transferred to another sheet? (Eg. Sheet 1 (A12) is linked to Sheet 2 (B35) via Importrange. When I import a cell containing "Yes" on Sheet 1 (A12), the cell it is attached to in Sheet 2 (B35) reflects it as "Agree")
2) Is it possible for the importrange content to change when it is being transferred to another sheet? (Eg. Sheet 1 (A12) is linked to Sheet 2 (B35) via Importrange. When I import a cell containing "Yes" on Sheet 1 (A12), the cell it is attached to in Sheet 2 (B35) reflects it as "Agree")