Dashboarding projected annual revenue
I am trying to dashboard my annual projected revenue. This will factor on the amount of the job and the expected completion date of the job. I know the scheduled job date and the expedted amountof time it takes to complete a job so it seems like this is doable but I cant seem to figure it out.
I have a sheet where I make clculations and store all of my dashboard data. Its called "dashboard data sheet". I use this to drive my dashboard wiidgets
On my "finance" sheet I have a $ column called "job amount", a date column called "job scheduled", and a drop down collumn called "job type".
I am trying to create a formula on my "dashboard data sheet" that will add 7 days to "job scheduled" if it is "job type" is "training", add 15 days if it is "job type" is "assessment", and add 30 days if "job type" is "development". Then, using that new date it should pull the amount from "job amount" and bucket it by year (i.e.,2019, 2020,2021, etc). I am trying to do this in one formula but i cant seem to figure this out. I have been trying for days! Any help is much appreciated.
Help Article Resources
Check out the Formula Handbook template!