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 '19 at 6:05
  • Thank you, I have edited my question with the link Jul 26 '19 at 18:40

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 '19 at 21:52
  • you need to delete everything in B3:M range so that arrayformula could roll out the data
    – user0
    Jul 26 '19 at 21:57
  • from b column, row 4 until M column? Jul 26 '19 at 21:57
  • from B3 to M6 - i.stack.imgur.com/4EfNU.png
    – user0
    Jul 26 '19 at 22:01
  • 1
    Thank you very much for the help! Jul 26 '19 at 22:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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