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

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.

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