Returning a value from a table if the date in the date column is TODAY

JPFORDTE

Hi guys,

so I'm trying to create a formula that will return a value if the column to its left is today's date. This will be for a metric widget I want to create which will update each month displaying the current months total cost. The table I want to create it from is below:

So I just want to create one cell under "This Months TC" basically returning the total cost for the month when today's date changes to that date.

Any help would be appreciate!

David Tutwiler

If you're going to do it per row, then this formula should work:

=IF(Date@row = TODAY(), [Total Cost]@row)