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.4K Get Help
- 465 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.4K Ideas & Feature Requests
- 86 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 518 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 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!
Trending in Formulas and Functions
- I need a formula that populates the due date based on the date that its approved. I want the date to be at the end of each quarter
- I have a source sheet of different items, rolling out on different dates for different stores. I am creating a target sheet of a rollout of one specific item. I want the target sheet to list all the s…
- = "Not Started" if NO boxes checked = "In Progress" if SOME boxes are checked = "Complete" if ALL boxes are checked for the attached example I manually changed status based on checked boxes, but I'm h…