How do I calculate the forecast income for the next 14 days from today.


Hi there,

I'm new to Smartsheet formulas and an struggling to gain the answer I want in order to report it.

I have 1 column with set fields advising expected payment dates and another with expected payment values.

I would like to sum the expected payment values due within the next 14 days to establish a cash flow forecast.

Could anyone help please?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!