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))
Try this. (Change Date t your column name)
The same version but with the below changes for your and others convenience.
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!
Workflow Consultant @ Get Done Consulting
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Happy to help!
Have a fantastic weekend & Happy Holidays!