Hi.
So, I am building a monthly income / expense forecasting model with a sales funnel and am looking to use one set of 'input cells' for the length of each stage - for example one called 'Months (or days) to convert a lead into a demo' - and 'months (or days) to convert a demo into a free trial', etc.
Based on the values that show here, I want to 'move revenue recognition' into the dates that are appropriate. So, I will be putting in the leads in the month columns, but I want the various stages to automatically change to the appropriate columns based on the 'time lags' put in as inputs in the assumptions / inputs area.
How would I do this? Any thoughts? Any help would be huge!
Best,
Tom