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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!