Have a spreadsheet with 2 worksheets
Worksheet #1 has data in row 1
Trying to create an IF statement on Worksheet #2 that when I fill down will
fill from Worksheet #1 row to Worksheet #2 column

This is a copy of my If statement:

=IF(Timesheet!E$1="","No Project",Timesheet!E$1)

When I try to fill down, it keeps the same cell location for each line

Any help would be greatly appreciated