I have this tab in Google spreadsheet [https://docs.google.com/spreadsheets/d/14ZBff8R6brLYWtfv70V-tyG0HE-sX_ejySvplQqZftM/edit#gid=1450402909]

Sheet All Tasks, Candice Tasks, Others People Tasks

At Sheet All Tasks I have a column to add the status from my projects.

Columns date, task, Comment, status

each row is a different task and assigned to a different person.

The column Status Has (Complete, In Progress).

I'm using this to import only my tasks to Candice Tasks =QUERY( ImportRange( "Key", "All Tasks!A3:I1000" ) , "where Col3 = 'Candice Tasks' order by Col2 desc")

But I need some way to update the status in Candice Tasks and automatically updates the cell in the column status at my Sheet All Tasks in the same task row I altered at my sheet.

Any Help Please?

  • pls share a copy of your sheet with example of desired result
    – user0
    Jul 26, 2019 at 6:05
  • Thank you, I have edited my question with the link Jul 26, 2019 at 18:40

1 Answer 1


paste in 'All Tasks'!A3 cell:



  • Hello, thank you, but i got this error #REF! Array result was not expanded because it would overwrite data in b3... Jul 26, 2019 at 21:52
  • you need to delete everything in B3:M range so that arrayformula could roll out the data
    – user0
    Jul 26, 2019 at 21:57
  • from b column, row 4 until M column? Jul 26, 2019 at 21:57
  • from B3 to M6 - i.stack.imgur.com/4EfNU.png
    – user0
    Jul 26, 2019 at 22:01
  • 1
    Thank you very much for the help! Jul 26, 2019 at 22:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.