Linking to other cells
So we have 2 sheets. New Projects sheet and Tasks sheet.
The New Projects one have 2 column. ID and name of the project, whenever we get a new project we insert the name and ID manually.
I want the Tasks sheet to have those column as well (ID and name) and I want it to be dynamic. Meaning we add on Projects sheet, it automatically appear in the Tasks sheet.
On excel, i'll just use: ='NewProject'!A1 and 'NewProject'!B1
and then just 'stretch' the formula down, so whenever I add something in NewProject, it will be added to Tasks, and if there's nothing, it will just stay blank.
So in excel i would get:
But here, it seems like I can't stretch the formula no matter what... How can I do it?