Formula for projects due to start in X no. of days
Grace
✭
Hi again,
Please need your help to correct my formula below. I wanted to count the number of projects that are due to start 14 days based on planned start dates but I am getting "Incorrect Argument Set" error.
Please don't get confused with the formula. The projects I created have 5 subtasks and as an alternative solution, I chose to pick up the numbers from the category column (the classification of the project) that are not blank. I'm not sure how to count by the projects headers hence my formula looked like the below.
=COUNTIFS(Category:Category, NOT(ISBLANK(@cell)), [Planned Start Date]1:[Planned Start Date]233, >TODAY(14))
Kind regards,
Grace
Tags:
Comments
-
Hi Luke,
Worked like a charm! Thank you!
Kind regards,
Grace
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!