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

How to link a value from Summary Sheet back to Intake Sheet
If I need the value from a Summary Sheet, to link it to the Intake sheet, is this how it should look like at the control center?
Report Doesn't Have the Option for Grouping, Sorting or Filtering
I have a report that is referencing a control center program. Other users that are setup as leads on the program and have the same admin permissions I do are able to edit the Group, Filter, Summarize and Sort settings of this report, but I can not. When I click the Columns button it just says "Loading" and even if I leave…
Add additional items to existing formula
I wish to ADD the following to my existing formula: [Reporting Period]@row="Jan", "Jan" [Reporting Period]@row="Mar", "Mar" [Reporting Period]@row="May", "May" [Reporting Period]@row="Jul", "Jul" [Reporting Period]@row="Sep", "Sep" [Reporting Period]@row="Nov", "Nov" Here is my current formula: =IF(CONTAINS("-",…