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?
Thanks
Best Answer
-
Oh dang. I also noticed that the formula cut out my less than criteria. This editor in the community does weird things when it starts seeing greater than and less than symbols. Try this one. 😁
=sumifs([Payment Column Name]:[Payment Column Name], [Due Date Column Name]:[Due Date Column Name], >=Today(), [Due Date Column Name]:[Due Date Column Name], <=Today(14))
Answers
-
I would us the =SUMIFS formula.
Try something like this.
=sumifs([Payment Column Name]:[Payment Column Name], [Due Date Column Name]:[Due Date Column Name], [Due Date Column Name]:[Due Date Column Name], <=Today(14))
-
Hi Mike,
thanks you for you assistance but the formula didn't work. I have attached a file (in excel)of what I am trying to achieve in Smartsheet.
Jason
-
Can you copy and paste the formula as you input it in smartsheet? That might give us some insight.
-
Oh dang. I also noticed that the formula cut out my less than criteria. This editor in the community does weird things when it starts seeing greater than and less than symbols. Try this one. 😁
=sumifs([Payment Column Name]:[Payment Column Name], [Due Date Column Name]:[Due Date Column Name], >=Today(), [Due Date Column Name]:[Due Date Column Name], <=Today(14))
-
Thanks Mike,
I appreciate your help with this. Have a great day.
Jason
-
Sure thing! Glad it worked for you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!