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!

Find more posts tagged with

Accepted answers

All comments

David Tutwiler

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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.