Thanks, but none of those were helpful
Check this out , this may help you.
First of all open the sheet on which you want to calculate the future data
And then please follow these steps:
The forecast is used to predict the future data/trends according to the previous data.
Please configure the forecast according to your requirements.
Hope it will help you.
the Forecast in the menu is greyed out...
Hello, I've deduced that I don't have 5 or more entries (only 4) which is why it won't produce a forecast.
Can I use a calculated field instead? I just need to use the monthly average of the Jan-Apr to estimate May-Dec.
You can use calculated fields,Please check the workbooks shared earlier(links).
They may help you out and guide you.