Forum Discussion
kaylaw
Jan 31, 2023Copper Contributor
Auto populate data from another sheet
Hello! I would like to auto-populate from the individual CSS sheets into the All Jobs sheet or vice versa. For example, if I add a job, in the All Jobs sheet, can it auto populate into the indivi...
Rodrigo_
Feb 01, 2023Iron Contributor
Hello kaylaw,
See the image below,
formula on B2:
=IFERROR(IF(HLOOKUP(Table3[[#Headers],[Job]],
INDIRECT("'"&$A$2&"'!$A$1:$E$22"),
ROWS($A$1:$A2),FALSE)="","",
HLOOKUP(Table3[[#Headers],[Job]],
INDIRECT("'"&$A$2&"'!$A$1:$E$22"),
ROWS($A$1:$A2),FALSE)),"")then drag (not copy) it to % Completed column. and then fill it downward.
sample file is on the attached.