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?