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

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!