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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!