I have =A1 on one cell and then a bunch of text on three cells beneath it and then =A2 on the fourth cell beneath it, how to make sure that when I drag down, it goes to A3 after leaving three cells and so forth?
Google-sheets – How to leave gaps while dragging down
google sheets
Related Solutions
It appears you don't need to change the data at all, just change the presentation of the data, i.e., formatting. Select column A, go to Format -> Number -> More formats -> More data and time formats, and set the desired format there:
New date/time data added to Column A will automatically be shown as above.
Instead of using drop-downs from data validation and formulas put all the information in a single sheet and use filters or filters views. For details see the official help article Filter your data - Docs editors Help
Related Topic
- Google Sheets – Prevent Dragging and Dropping from Changing Cell References
- Google Sheets – Filling Columns with Formulas Without Dragging
- Google-sheets – Auto-fill date function changes the YEAR and not the day
- Google Sheets – Stretch Formula Down Column with Same Input
- Google-sheets – How to keep borders when dragging down to fill cells
- Google Sheets – Copy Formula to All Cells Below and Increment by X
Best Answer
To achieve the following:
and so on, use a formula such as
=offset(A$1, row(D1)/3, 0)in cell D1. This offsets the reference to A1 by the row number divided by 3 (the result is rounded down automatically). When copied down the column, it will offset the cell positions correctly.