Formula help to calculate annualized specific to a specific starting month
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
-
Including @Paul Newcome
I think your original formula was set up to split the Annualized Project Impact ($) across the remaining months of the year.
If you want it to be split across 12 months, starting in the month of the Planned Project Savings Start Date, you could use this formula:
Jan '23:
=IF(MONTH([Planned Project Savings Start Date]@row) <= 1, [Annualized Project Impact ($)]@row / 12)
Feb '23:
=IF(MONTH([Planned Project Savings Start Date]@row) <= 2, [Annualized Project Impact ($)]@row / 12)
And so on, just changing the month number in your formula for each column.
Paul, I'm curious if you have other ideas too!
-
@Julie Fortney Thanks for the tag.
@Lisa Welch Julie's solution should work for you based on the way I am reading your request.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!