Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
time based reports?
I'm sure what I'm looking to do is not that difficult, I just can't find a way to achieve it. What I have is a sheet that consists of quote amounts ($) that are relative to a quote date. What I want to do is to look at how many dollars we have quoted that are on quotes a month old, 2 months old, etc.
Ideally this would be something that I could write with a formula right in my current Open Quotes sheet, but if I have to do it with a Report, then I will. I see in the report builder that I can make a report based on a specific date, but that would require that I go into the report and constantly update the date. What I want is a constantly up to date solution that is always looking...
Is there a clean way of achieving this?
Comments
-
You can do this with a SUMIFS formula.
The SUMIFS requires the range you want to sum, the range for the first criteria to use, the actual first critiera to use, the range for the second criteria to use, the actual second criteria, etc.
So your forumula looks like this:
=SUMIFS([Range to sum], [Range of dates], ">=start date",[Range of dates],"<=end date") Note that the dates and the operators are in double quote marks.
My smartsheet forumla looks like this:
=SUMIFS([Column2]1:[Column2]5, [Primary Column]1:[Primary Column]5, ">=01/01/2016", [Primary Column]1:[Primary Column]5, "<=01/31/2016)")
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives