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.

Building a report based on the calendar, and I need to use "YESTERDAY"

Michael Macygin
Michael Macygin ✭✭✭
in Archived 2017 Posts

I'm building a report that will show things that are happening TODAY and in the FUTURE.  I can build each of those separately, but together seems to be an issue.  I built a filter based upon date being YESTERDAY, but when I go back to check it, it has placed the actual date in the field.  Is there a more permanent solution to using YESTERDAY as a filter in reporting?

Tags:
· Share on FacebookShare on Twitter

Comments

  • Kara Lumley
    Kara Lumley Employee

    Hi Michael,

    In the When reporting criteria, did you try "in the last" 1 day?

    · Share on FacebookShare on Twitter
  • Michael Macygin
    Michael Macygin ✭✭✭

    My out put in my report are things that are happening today and into the future.  I don't want to see anything before today.  Using " greater than Yesterday" in the formula gives me the desired output, but I'm concerned that when it saves the actual formula, the YESTERDAY is replaced with yesterday's date.  Fine for today, but once I get another day or two into the week, I'm beginning to see things that happened in the past.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories