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
Hi All, I’m looking for some guidance on how to best structure an activity plan in Smartsheet. I need to track and display: Date ranges for each activity Activity month Monthly budget Key points such as promos/offers Major events happening during the same period (e.g., national holidays, International Women’s Day, etc.)…
I've just added six sheet summary fields to a sheet. But I have to add the same six fields to another eight sheets. I've been looking in the posts here, and I don't see anyone addressing whether there's any way to copy/paste the
I have given someone access as an Admin to allow them to create new sheets and edit existing and they keep being told they do not have access to edit. What could be causing this?
