Hi,
My company's IT person has got customer data automatically adding to the bottom of a Google Sheet.
We then have an =importrange into another sheet where we will be adding to that data with formulas.
So for example, we have a formula to work out how many days ago the customer was created. =DAYS(TODAY(),W2).
The problem is, as more data gets added every day, the formula needs to get dragged down as the rows get added. We can't be doing this manually as we are setting up automated reporting dashboards.
If we drag down extra rows below the data, the Julian date is displayed - which our reporting dashboard will treat as data and it'll therefore throw everything off.
Does anybody know of a was to get the formula to go down as more data is added to the sheet?
Thanks,
Andrew
Bookmarks