Using TODAY() in a Sheet Summary
I am trying to get a sheet summary formula to report a cell based no todays date. I tried the following formula (and a few similar variations) with no luck. What am i doing wrong? should i be going the vlook
up route? Thanks!
=IF(Date:Date = TODAY(), [Total Completed C-Boxes]@row,"")
Best Answer
-
Try an INDEX/MATCH there. I like INDEX/MATCH over VLOOKUP because it will still work even if columns get moved around in the sheet.
=INDEX([Total Completed C-Boxes]:[Total Completed C-Boxes], MATCH(TODAY(), Date:Date, 0))
In English - find the value in the [Total Completed C-Boxes] column on the row where the Date value equals today.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Try an INDEX/MATCH there. I like INDEX/MATCH over VLOOKUP because it will still work even if columns get moved around in the sheet.
=INDEX([Total Completed C-Boxes]:[Total Completed C-Boxes], MATCH(TODAY(), Date:Date, 0))
In English - find the value in the [Total Completed C-Boxes] column on the row where the Date value equals today.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
So helpful, worked like a charm. thanks @Jeff Reisman !
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!