nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Report Help

Jason Rowe

I am trying to build a report that is looking at one "DATE" column and shows everything that is between 45 to 90 days from today. The trouble I am having is getting it to be dynamic rather than changing the date everyday. Is this possible? Any help is appreciated.

Thanks,

Jason

Comments

Brett Evans

Make a column on the sheet with the formula:

=if(AND(DATE1 < today()-45, DATE1 < today()-90 ), "on report", "not on report")

Jason Rowe

Great Idea. Thanks!

Brett Evans

Play arouind with the greater than/less than. I wrote that without testing.

Sign in to join the Community!

Quick Links

Find more posts tagged with

Construction

Reports