1

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

paste in 'All Tasks'!A3 cell:

=ARRAYFORMULA({
 INDIRECT("Candice!A4:M"&COUNTA(Candice!B4:B)+3); 
 INDIRECT("Dhruv!A4:M"&COUNTA(Dhruv!B4:B)+3)})

0

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