Predicting trajectory from current data

Im looking for a solution where i have numeric data created on a board when the source data stage changes > post the stage and numeric data values and the current date.

this works well.

but now i need to find a way to then predict, based upon the data what the stage will be and numeric data values for future time periods and then post this onto a chart to show the predicted trajectory.

Hey Lee!

I’m wondering if an “IF” function within the formula column could be helpful here? For instance, if you set up a formula column to return a specific value if x condition is met and a different value if y condition is met.

Would you be able to share a little more context about the specific predictions you’re looking to be able to make? Perhaps we have a use case previously workshopped that we can dig into to see if it would apply.