Welcome!

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

Currently using this but doesn't work:

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

Please Help!

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

Thanks Andree!

Happy to help!

Have a fantastic weekend & Happy Holidays!

Best,

Andrée

Capturing Cost Savings by the month
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Automation to send Reminder @ 60d, 30d, etc
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
How do I share a report document to an external client without having to give full access to the doc
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…