TODAY Formula

System

This discussion was created from comments split from: Returning a value from a table if the date in the date column is TODAY.

Kayleigh Colon

https://community.smartsheet.com/discussion/comment/306265#Comment_306265

Hi, I am looking for a similar formula, but the above isn't working for me. I have a dashboard for a lab testing schedule. I want it to pull from a pacing sheet. I would like my metric on the dashboard to return the # of hours scheduled each day. So, for today it would show 44hrs scheduled, and then tomorrow it would show 18hrs etc.

Paul Newcome

I would suggest a sheet summary field containing something along the lines of

=INDEX([Total Hours]:[Total Hours], MATCH(TODAY(), Date:Date, 0))

Then reference the sheet summary field in your metrics widget.

Genevieve P.

@Kayleigh Colon sending you a tag in case you missed the comment from Paul! 🙂

Kayleigh Colon

This works, thank you! :)

Paul Newcome

Happy to help. 👍️