Monday, December 4, 2017

yogi_Annual goal split into the months with auto update based on results that month

Google Spreadsheet   Post  #2310

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-04-2017
question by: Heather Etzel
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/Q_AUXk4GQyk;context-place=forum/docs
Annual goal split into the months with auto update based on results that month
I am looking to split up our annual goal of lets say 96 (this will need the ability to be changed due to market conditions for the year we are projecting) active listing into a monthly goal to achieve that 96. BUT with the ability to have the numbers auto update for the following months to still achieve that goal based on the actual number obtained in prior months.

So say the 96 is projecting we need 8 listings a month starting in January.. and we end up obtaining 10 listings.. I want it to auto adjust to maybe say like 6 listings in Feb and 8 in the remainder months etc.. can this happen and update as we plug in the actual obtained listings somewhere.. possibly a hidden sheet that feeds the numbers? 

The yellow is where I want the figures to be shown. Thank you. 


https://drive.google.com/open?id=1y2C6i34JxMZavkHO0c0Wn5tXB2FjotV4qUTHPBARPCo