Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Countif Tomorrow
Hello there, I'd like to be able to count how many people are arriving today, tomorrow, and the day after based on an Arrival Date column in Smartsheet. For today, I simply use the =countif(Today()) formula. Is there a way to say today +1, today +2, etc.?
Best Answer
-
Never mind, answered my own question! You simply enter Today(1) for tomorrow, Today (2) for day after, etc.
Answers
-
Never mind, answered my own question! You simply enter Today(1) for tomorrow, Today (2) for day after, etc.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 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!