What Coda Formula I can Use to Forecast These Data from 2021, 2022 and YTD 2023?

[Renee_O]

Hi guys,

Is there any Coda Formula I can use to forecast the possible Q4 2023 Total Leads, Active Discussion, Converted Events and Event Total based on these 2021, 2022, and YTD 2023 data?

Any suggestions on how to do it is welcome!

Thank you

[Nick_HE]

Formulas aside, let’s look at just the math first.

I think what makes a good projection differs by business - can you explain how you would want to do it mathematically, in broad terms?

For example, Q3’23/Q3’22 * Q4’22 (i.e., scale last year’s Q4 in proportion to the Q3 YoY performance)?

[Scott_Collier-Weir]

We should collapse threads. Been in discussion over here

Coda Formula that I can Use to Forecast These Data from 2021, 2022 and YTD 2023

Hi guys, Is there any Coda Formula I can use to forecast the possible Q4 2023 Total Leads, Active Discussion, Converted Events and Event Total based on these 2021, 2022, and YTD 2023 data? [image] Thank you