Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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!
Andrée
When using automation to copy checked rows from source sheet, no destination sheets populate for me to choose from even though I am Admin on both sheets. Has anyone experienced this? Any trouble shoots or resolutions? Thanks.
Hello Smartsheet Friends! I recently switched jobs and once again working at a company that uses Smartsheet (hooray!). That said my skills are a little rusty, and I'm struggling with a basic update request automation. I've added a checkbox column titled 'Product Owner Update'. The intent, is that when a user checks the…
Hi My team have a list of projects they are working on. I want to prompt them for a weekly update that will ask them to populate these fields - RAG Status , Progress this week , Plan Next week, Risks/Decision/Issues , Details Then i can create a dashboard showing only this weeks info but i have the repository in the back…
