Formula help to calculate annualized specific to a specific starting month

Options

I have a formula working correctly, (thanks to Paul Newcome) where a month is entered and an amount (Annualized Project Impact ($)) which then populates to the correct months, based on that start date then carries across the remaining months.

Here is the existing formula for that =IF(MONTH([Planned Project Savings Start Date]@row) <= 1, [Annualized Project Impact ($)]@row / (12 - MONTH([Planned Project Savings Start Date]@row) + 1))

What I need to include is a formula that divides the "Annualized Project Impact ($)" by 12 then starts entry in the "Planned Project Savings Start Date" month.

For the below image the correct monthly amount should be $2,500 NOT $5,000


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!