Expand description
Data › Forecast › Forecast Sheet: a new sheet with the history, a FORECAST.ETS column, the FORECAST.ETS.CONFINT confidence bounds, optional FORECAST.ETS.STAT statistics and a chart.
Like Excel, the sheet holds a copy of the timeline and values (sorted by time) and live formulas over that copy, so the forecast follows edits to the copied history.