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!

Want to Count "Total number of Tasks that are due in next 7 days"

Rafsun Royal

Currently using this but doesn't work:

=COUNTIF([Production Move Date]14:[Production Move Date]149, >=TODAY(7))

Please Help!

Find more posts tagged with

Comments

Andrée Starå

Hi Rafsun,

Try this. (Change Date t your column name)

=COUNTIF(Date:Date; <=TODAY(7))

The same version but with the below changes for your and others convenience.

=COUNTIF(Date:Date, <=TODAY(7))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Rafsun Royal

Thanks Andree!

Andrée Starå

Happy to help!

Have a fantastic weekend & Happy Holidays!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Run Generate Document Workflow On Multiple Rows
Hello everyone, I have several rows (different entries) that I would like to enter on a custom form using the "Generate Document" workflow. I did a test run and it just generated "individual" PDF form per row - and not multiple rows merged into one form as I was expected. Is there another way or methodology around this or…
Sharing a Single Smartsheet with External Partners (No SSO Access)
Hi Smartsheet Community, I’m hoping you can help clarify a Smartsheet sharing question. I’m trying to share one specific sheet from my Smartsheet plan with two external colleagues from our partner organization. Several colleagues have mentioned they’ve successfully shared sheets with external partners before, so I’m hoping…
Form Creation
Is it possible to create a form on sheet 1 with information from sheet 2? On Sheet 1, I'm tracking what we ship and receive. On Sheet 2, I'm tracking the shipping requirements. I want to pull data from this sheet for a shipping request form on sheet 1.