Help automate the field update in formula so that my summary is always showing the most recent data

I am currently doing some simple data entry in Smartsheet for my company. I am fairly new to Smartsheet and I am still working on my skills in Excel. For one of my sheet summaries, I am using the formula

=SUMIF(Date:Date, ="07/14/20", [COLUMN NAME]:[COLUMN NAME])

to sum the data in [COLUMN NAME] based on the current date. I do daily updates and so every day that I do my updates, I have to go into my formula and manually change the date so that it lines up with the most recent date. Is there anyway for me to automate this so that the formula always uses the date from row 1 in the Date column?

Find more posts tagged with

Accepted answers

Paul Newcome

Try using a TODAY function like so...

=SUMIF(Date:Date, = TODAY(), [COLUMN NAME]:[COLUMN NAME])

All comments

Paul Newcome

Try using a TODAY function like so...

=SUMIF(Date:Date, = TODAY(), [COLUMN NAME]:[COLUMN NAME])

Gabriel Perez-Pujols

@Paul Newcome so I tried this formula and I now understand how the TODAY function works but unfortunately my result keeps coming up as 0 when I use this function. When I replace "TODAY()" with the current date though it still works fine.

Paul Newcome

How are the dates entered in your Date column? Is the column formatted as a date type column in the column property settings?

Gabriel Perez-Pujols

@Paul Newcome That's what the issue was. I was using the primary column as my date column which automatically makes it a text/number column. I created a new column as a date type column and the formula worked perfectly. Thank you again for all of your help Paul! You truly are a blessing to the community and newbies like myself.

Paul Newcome

Happy to help! 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.