I am trying to compare 2 date columns with an odd result

Ryan Abraham

I am trying to count the number of submissions on a daily basis with =COUNTIF({Loans Range 1}, =[Begin Date]@row).

Most of the formulas return the correct number of submissions.

What it looks like it is doing is applying the submissions entered after a certain time (5 PM?) to the next day.

Dependencies are disabled

Resources management is disabled

Is there anything I can do to have it read the date only and not the time?

Smartsheet issue.png

Find more posts tagged with

Accepted answers

Eric Law

@Ryan Abraham Try creating a helper column, called DateOnly and apply that to the Created Date column and refer to that. It will remove the time and just give you a date to reference.

All comments

Eric Law

@Ryan Abraham Try creating a helper column, called DateOnly and apply that to the Created Date column and refer to that. It will remove the time and just give you a date to reference.

Ryan Abraham

@Eric Law Thanks, that worked! This sheet is getting big with all the workarounds haha

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.