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

Unlicensed Users cannot enter data in the sheet, when they could before the changes
I have tried to set them as Edit - can share, Edit - cannot share, and commenter and nothing works, they cannot add data to the sheet. Does anyone have a solution?
How to Preserve INDEX Formula Data When Archiving Row?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
2 of 5 automation workflows in a SMartSheet randomly stopped performing?
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.